APPS.PAY_CN_PAYSLIP_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1461: FROM hr_all_organization_units hou

1457: ,hr_general.decode_lookup('CN_PROVINCE',hl.town_or_city) province
1458: ,ft.territory_short_name country
1459: ,hl.postal_code
1460: ,hl.telephone_number_1
1461: FROM hr_all_organization_units hou
1462: ,hr_locations hl
1463: ,fnd_territories_tl ft
1464: WHERE hou.organization_id = p_employer_id
1465: AND hou.location_id = hl.location_id