The following lines contain the word 'select', 'insert', 'update' or 'delete':
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 ;
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')) ;