DBA Data[Home] [Help]

APPS.PER_US_EEO4A_PKG dependencies on HR_LOCATIONS

Line 888: hr_locations hl

884: NVL(hl.town_or_city,' ') town_or_city,
885: NVL(hl.region_1,' ') county,
886: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
887: FROM hr_all_organization_units hou,
888: hr_locations hl
889: WHERE hou.location_id = hl.location_id
890: AND hou.business_group_id = g_business_group_id
891: AND hou.organization_id = g_business_group_id;
892: