APPS.XLE_REGISTRATIONS_VAL_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 37

   SELECT jur.legislative_cat_code,
          DECODE(p_entity_type, 'LE' , jur.registration_code_le,
                                'ETB', jur.registration_code_etb) registration_code,
          DECODE(p_entity_type, 'LE' , jur.required_le_flag,
                                'ETB', jur.required_etb_flag) required_flag,
          geo.geography_code country_code
   FROM   xle_jurisdictions_b jur,
          hz_geographies      geo
   WHERE  jur.geography_id    = geo.geography_id
   AND    jur.jurisdiction_id = p_jurisdiction_id
   AND    TRUNC(SYSDATE) BETWEEN TRUNC(Nvl(jur.effective_from, SYSDATE))
                            AND TRUNC(Nvl(jur.effective_from, SYSDATE))
   AND    TRUNC(SYSDATE) BETWEEN TRUNC(Nvl(geo.start_date, SYSDATE))
                            AND TRUNC(Nvl(geo.end_date, SYSDATE));

Line: 55

SELECT registration_id
FROM   xle_registrations
WHERE  source_table    = p_source_table
AND    jurisdiction_id = p_jurisdiction_id
AND    registration_number = p_registration_number
AND    (effective_to is null or effective_to >= sysdate);