DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 861: hr_organization_units hou

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:
865: l_action_information_id number(15);

Line 960: hr_organization_units hou,

956: select paei.aei_information7 legal_entity_id,
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