APPS.XLE_LE_TIMEZONE_GRP SQL Statements

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

Line: 177

    SELECT  hrl.timezone_code ,
            ftb.upgrade_tz_id
        INTO x_timezone_code,
             x_timezone_id
        FROM XLE_ENTITY_PROFILES xlep,
             XLE_REGISTRATIONS reg,
             HR_LOCATIONS_ALL hrl,
             fnd_timezones_b ftb
          WHERE xlep.legal_entity_id = reg.source_id
            AND reg.source_table = 'XLE_ENTITY_PROFILES'
            AND reg.identifying_flag = 'Y'
            AND nvl(reg.effective_from,sysdate) <= sysdate
            AND nvl(reg.effective_to, sysdate) >= sysdate
            AND reg.location_id = hrl.location_id
            AND xlep.legal_entity_id = p_legalentity_id
            AND ftb.timezone_code = hrl.timezone_code ;

Line: 1304

    SELECT timezone_code ,
           upgrade_tz_id
    INTO   G_SERVER_TZ_CODE ,
           G_SERVER_TZ_ID
    FROM   fnd_timezones_b
    WHERE  upgrade_tz_id =
           to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')) ;