APPS.PER_PERUSHRM_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 752: ,hr_locations_all hl

748: ,hl.region_2 STATE
749: From
750: per_all_people_f ppf
751:
752: ,hr_locations_all hl
753: ,hr_soft_coding_keyflex hscf
754: ,per_all_assignments_f paf
755: ,per_periods_of_service pps
756: ,hr_organization_information hoi4

Line 807: ,hr_locations_all hl

803: ,hl.region_2 STATE
804: From
805: per_all_people_f ppf
806:
807: ,hr_locations_all hl
808: ,hr_soft_coding_keyflex hscf
809: ,per_all_assignments_f paf
810: ,per_periods_of_service pps
811: ,hr_organization_information hoi4

Line 862: v_state hr_locations_all.region_2%TYPE;

858:
859: v_person_id per_people_f.person_id%TYPE;
860: v_first_name per_people_f.first_name%TYPE;
861: v_last_name per_people_f.last_name%TYPE;
862: v_state hr_locations_all.region_2%TYPE;
863: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
864: g_delimiter varchar2(1) := fnd_global.local_chr(10);
865:
866: BEGIN

Line 1184: ,hr_locations_all hl ,per_jobs job

1180: From
1181: per_all_people_f ppf
1182: ,per_all_assignments_f paf
1183: ,hr_soft_coding_keyflex hscf
1184: ,hr_locations_all hl ,per_jobs job
1185: ,per_periods_of_service pps
1186: ,hr_organization_information hoi4
1187: ,hr_organization_information hoi3
1188: ,hr_organization_information hoi2

Line 1238: ,hr_locations_all hl ,per_jobs job

1234: From
1235: per_all_people_f ppf
1236: ,per_all_assignments_f paf
1237: ,hr_soft_coding_keyflex hscf
1238: ,hr_locations_all hl ,per_jobs job
1239: ,per_periods_of_service pps
1240: ,hr_organization_information hoi4
1241: ,hr_organization_information hoi3
1242: ,hr_organization_information hoi2

Line 1547: ,hr_locations_all hl ,per_jobs job

1543: From
1544: per_all_people_f ppf
1545: ,per_all_assignments_f paf
1546: ,hr_soft_coding_keyflex hscf
1547: ,hr_locations_all hl ,per_jobs job
1548: ,per_periods_of_service pps
1549:
1550: Where
1551: pps.person_id = ppf.person_id

Line 1594: ,hr_locations_all hl ,per_jobs job

1590: From
1591: per_all_people_f ppf
1592: ,per_all_assignments_f paf
1593: ,hr_soft_coding_keyflex hscf
1594: ,hr_locations_all hl ,per_jobs job
1595: ,per_periods_of_service pps
1596:
1597: Where
1598: pps.person_id = ppf.person_id

Line 1642: v_state hr_locations_all.region_2%TYPE;

1638: v_date_start per_periods_of_service.date_start%TYPE;
1639: v_header number;
1640: v_buffer varchar2(120);
1641: v_boolean boolean;
1642: v_state hr_locations_all.region_2%TYPE;
1643:
1644:
1645: BEGIN
1646: hr_utility.set_location('Entered p_output_new_hire_null',10);