DBA Data[Home] [Help]

APPS.PAY_SA_GOSI_REPORTS dependencies on HR_LOCATIONS_ALL

Line 2724: from hr_locations_all hla

2720: cursor get_town_old (l_assignment_id NUMBER, l_effective_date Date) is
2721: select hla.town_or_city
2722: ,hla.region_2
2723: ,hla.region_3
2724: from hr_locations_all hla
2725: ,hr_organization_units hou
2726: ,per_all_assignments_f paa
2727: where paa.organization_id = hou.organization_id
2728: and hou.location_id = hla.location_id