DBA Data[Home] [Help]

APPS.XLE_LE_TIMEZONE_GRP dependencies on FND_TIMEZONES_B

Line 184: fnd_timezones_b ftb

180: x_timezone_id
181: FROM XLE_ENTITY_PROFILES xlep,
182: XLE_REGISTRATIONS reg,
183: HR_LOCATIONS_ALL hrl,
184: fnd_timezones_b ftb
185: WHERE xlep.legal_entity_id = reg.source_id
186: AND reg.source_table = 'XLE_ENTITY_PROFILES'
187: AND reg.identifying_flag = 'Y'
188: AND nvl(reg.effective_from,sysdate) <= sysdate

Line 1308: FROM fnd_timezones_b

1304: SELECT timezone_code ,
1305: upgrade_tz_id
1306: INTO G_SERVER_TZ_CODE ,
1307: G_SERVER_TZ_ID
1308: FROM fnd_timezones_b
1309: WHERE upgrade_tz_id =
1310: to_number( fnd_profile.value_specific('SERVER_TIMEZONE_ID')) ;
1311:
1312: END IF ;