APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1589: FROM hr_all_organization_units hou

1585: ,hr_general.decode_lookup('CN_PROVINCE',hl.town_or_city) province
1586: ,ft.territory_short_name country
1587: ,hl.postal_code
1588: ,hl.telephone_number_1
1589: FROM hr_all_organization_units hou
1590: ,hr_locations hl
1591: ,fnd_territories_tl ft
1592: WHERE hou.organization_id = p_employer_id
1593: AND hou.location_id = hl.location_id