1433: paf.location_id location_id,
1434: hrl.location_code location_code,
1435: paf.effective_end_date max_end_date
1436: from hr_locations_all hrl,
1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN
1441: pay_payroll_actions ppa_arch -- PYUGEN
1434: hrl.location_code location_code,
1435: paf.effective_end_date max_end_date
1436: from hr_locations_all hrl,
1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN
1441: pay_payroll_actions ppa_arch -- PYUGEN
1442: where