DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on HR_LOCATIONS_ALL

Line 3413: FROM xle_registrations reg,hr_locations_all loc

3409: BEGIN
3410: --retriving city
3411: SELECT loc.town_or_city
3412: INTO l_city
3413: FROM xle_registrations reg,hr_locations_all loc
3414: WHERE reg.source_id = g_legal_entity_id
3415: AND reg.source_table = 'XLE_ENTITY_PROFILES'
3416: AND reg.identifying_flag = 'Y'
3417: AND reg.location_id =loc.location_id

Line 3574: FROM xle_registrations reg,hr_locations_all loc

3570: BEGIN
3571: --retriving city
3572: SELECT loc.town_or_city
3573: INTO l_city
3574: FROM xle_registrations reg,hr_locations_all loc
3575: WHERE reg.source_id = g_establishment_id
3576: AND reg.source_table = 'XLE_ETB_PROFILES'
3577: AND reg.identifying_flag = 'Y'
3578: AND reg.location_id =loc.location_id