eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSHRM_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 750: per_all_people_f ppf

746: ,ppf.LAST_NAME LAST_NAME
747: ,ppf.FIRST_NAME FIRST_NAME
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

Line 805: per_all_people_f ppf

801: ,ppf.LAST_NAME LAST_NAME
802: ,ppf.FIRST_NAME FIRST_NAME
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

Line 1181: per_all_people_f ppf

1177: select
1178: count(ppf.person_id)
1179:
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

Line 1235: per_all_people_f ppf

1231: select
1232: count(ppf.person_id)
1233:
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

Line 1544: per_all_people_f ppf

1540: ,pps.date_start
1541: ,hl.region_2 STATE
1542:
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

Line 1591: per_all_people_f ppf

1587: ,pps.date_start
1588: ,hl.region_2 STATE
1589:
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

Line 1632: v_person_id per_all_people_f.person_id%TYPE;

1628: And ppf.per_information7 is NULL
1629: Order by 2,3;
1630:
1631:
1632: v_person_id per_all_people_f.person_id%TYPE;
1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;

Line 1633: v_last_name per_all_people_f.last_name%TYPE;

1629: Order by 2,3;
1630:
1631:
1632: v_person_id per_all_people_f.person_id%TYPE;
1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;
1637: v_dob per_all_people_f.date_of_birth%TYPE;

Line 1634: v_first_name per_all_people_f.first_name%TYPE;

1630:
1631:
1632: v_person_id per_all_people_f.person_id%TYPE;
1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;
1637: v_dob per_all_people_f.date_of_birth%TYPE;
1638: v_date_start per_periods_of_service.date_start%TYPE;

Line 1635: v_middle_name per_all_people_f.middle_names%TYPE;

1631:
1632: v_person_id per_all_people_f.person_id%TYPE;
1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;
1637: v_dob per_all_people_f.date_of_birth%TYPE;
1638: v_date_start per_periods_of_service.date_start%TYPE;
1639: v_header number;

Line 1636: v_ssn per_all_people_f.national_identifier%TYPE;

1632: v_person_id per_all_people_f.person_id%TYPE;
1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;
1637: v_dob per_all_people_f.date_of_birth%TYPE;
1638: v_date_start per_periods_of_service.date_start%TYPE;
1639: v_header number;
1640: v_buffer varchar2(120);

Line 1637: v_dob per_all_people_f.date_of_birth%TYPE;

1633: v_last_name per_all_people_f.last_name%TYPE;
1634: v_first_name per_all_people_f.first_name%TYPE;
1635: v_middle_name per_all_people_f.middle_names%TYPE;
1636: v_ssn per_all_people_f.national_identifier%TYPE;
1637: v_dob per_all_people_f.date_of_birth%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;