APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on HR_LOCATIONS

Line 926: from hr_locations hl,

922: hl.region_3,
923: hl.postal_code,
924: hl.country,
925: hl.telephone_number_1
926: from hr_locations hl,
927: hr_organization_units hou
928: where hou.organization_id = p_legal_entity_id
929: and hou.location_id = hl.location_id;
930:

Line 1058: hr_locations hl

1054: hou.name legal_entity_name,
1055: hl.telephone_number_1
1056: from per_assignment_extra_info paei,
1057: hr_organization_units hou,
1058: hr_locations hl
1059: where paei.assignment_id = p_assignment_id
1060: and paei.information_type = 'ZA_SPECIFIC_INFO'
1061: and paei.aei_information7 = hou.organization_id
1062: and hou.location_id = hl.location_id;