Problem in query that returns information from Oracle customers by site

Summary:

My query should have only the records that were modified in sysdate

SELECT

       /*********hz_parties******************/

       hp.party_id,

       hp.party_name,

       hp.jgzz_fiscal_code,

       To_char(hp.creation_date, 'DD/MM/YYYY'),

       /*********hz_party_sites******************/

       hps.party_site_id,

       hps.party_site_number,

       /*********hz_organization_profiles******************/

       hop.attribute2,

       hop.attribute1,

       hop.attribute3,

       /*********hz_locations******************/

       hzl.attribute6,

       hzl.postal_code,

       hzl.address1,

       hzl.addr_element_attribute3,

       hzl.state,

       hzl.addr_element_attribute2,

       hzl.city,

       hzl.attribute1,

       CASE

              WHEN hzl.attribute7 IS NULL THEN NULL

              ELSE

                    (

                    SELECT vst1.description

                    FROM   fnd_vs_values_b VSV1,

                           fnd_vs_values_tl VST1

                    WHERE  vsv1.value = hzl.attribute7

                    AND    vsv1.attribute_category = 'Periodo de facturación'

                    AND    vsv1.value_id = vst1.value_id

                    AND    vsv1.enterprise_id = vst1.enterprise_id

                    AND    vsv1.sandbox_id = vst1.sandbox_id

                    AND    vst1.language = 'E')

       END "PeriodoFacturacionId",

       hzl.attribute4 "LimiteCredito",

       hzl.attribute3 "ClienteId",