APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS

Line 860: from hr_locations hl,

856: hl.region_3,
857: hl.postal_code,
858: hl.country,
859: hl.telephone_number_1
860: from hr_locations hl,
861: hr_organization_units hou
862: where hou.organization_id = p_legal_entity_id
863: and hou.location_id = hl.location_id;
864:

Line 961: hr_locations hl

957: hou.name legal_entity_name,
958: hl.telephone_number_1
959: from per_assignment_extra_info paei,
960: hr_organization_units hou,
961: hr_locations hl
962: where paei.assignment_id = p_assignment_id
963: and paei.information_type = 'ZA_SPECIFIC_INFO'
964: and paei.aei_information7 = hou.organization_id
965: and hou.location_id = hl.location_id;