APPS.PER_PERUSHRM_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 760: ,hr_locations_all hl

756: ,hl.region_2 STATE
757: From
758: per_all_people_f ppf
759:
760: ,hr_locations_all hl
761: ,hr_soft_coding_keyflex hscf
762: ,per_all_assignments_f paf
763: ,per_periods_of_service pps
764: ,hr_organization_information hoi4

Line 815: ,hr_locations_all hl

811: ,hl.region_2 STATE
812: From
813: per_all_people_f ppf
814:
815: ,hr_locations_all hl
816: ,hr_soft_coding_keyflex hscf
817: ,per_all_assignments_f paf
818: ,per_periods_of_service pps
819: ,hr_organization_information hoi4

Line 870: v_state hr_locations_all.region_2%TYPE;

866:
867: v_person_id per_people_f.person_id%TYPE;
868: v_first_name per_people_f.first_name%TYPE;
869: v_last_name per_people_f.last_name%TYPE;
870: v_state hr_locations_all.region_2%TYPE;
871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
872: g_delimiter varchar2(1) := fnd_global.local_chr(10);
873:
874: BEGIN

Line 1192: ,hr_locations_all hl ,per_jobs job

1188: From
1189: per_all_people_f ppf
1190: ,per_all_assignments_f paf
1191: ,hr_soft_coding_keyflex hscf
1192: ,hr_locations_all hl ,per_jobs job
1193: ,per_periods_of_service pps
1194: ,hr_organization_information hoi4
1195: ,hr_organization_information hoi3
1196: ,hr_organization_information hoi2

Line 1246: ,hr_locations_all hl ,per_jobs job

1242: From
1243: per_all_people_f ppf
1244: ,per_all_assignments_f paf
1245: ,hr_soft_coding_keyflex hscf
1246: ,hr_locations_all hl ,per_jobs job
1247: ,per_periods_of_service pps
1248: ,hr_organization_information hoi4
1249: ,hr_organization_information hoi3
1250: ,hr_organization_information hoi2

Line 1555: ,hr_locations_all hl ,per_jobs job

1551: From
1552: per_all_people_f ppf
1553: ,per_all_assignments_f paf
1554: ,hr_soft_coding_keyflex hscf
1555: ,hr_locations_all hl ,per_jobs job
1556: ,per_periods_of_service pps
1557:
1558: Where
1559: pps.person_id = ppf.person_id

Line 1602: ,hr_locations_all hl ,per_jobs job

1598: From
1599: per_all_people_f ppf
1600: ,per_all_assignments_f paf
1601: ,hr_soft_coding_keyflex hscf
1602: ,hr_locations_all hl ,per_jobs job
1603: ,per_periods_of_service pps
1604:
1605: Where
1606: pps.person_id = ppf.person_id

Line 1650: v_state hr_locations_all.region_2%TYPE;

1646: v_date_start per_periods_of_service.date_start%TYPE;
1647: v_header number;
1648: v_buffer varchar2(120);
1649: v_boolean boolean;
1650: v_state hr_locations_all.region_2%TYPE;
1651:
1652:
1653: BEGIN
1654: hr_utility.set_location('Entered p_output_new_hire_null',10);