DBA Data[Home] [Help]

APPS.PER_US_EEO4_PKG dependencies on HR_LOCATIONS

Line 910: hr_locations hl

906: NVL(hl.town_or_city,' ') town_or_city,
907: NVL(hl.region_1,' ') county,
908: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
909: FROM hr_all_organization_units hou,
910: hr_locations hl
911: WHERE hou.location_id = hl.location_id
912: AND hou.business_group_id = g_business_group_id
913: AND hou.organization_id = g_business_group_id;
914: