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_ASSIGNMENTS_F

Line 754: ,per_all_assignments_f paf

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
757: ,hr_organization_information hoi3
758: ,hr_organization_information hoi2

Line 809: ,per_all_assignments_f paf

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
812: ,hr_organization_information hoi3
813: ,hr_organization_information hoi2

Line 823: And not exists (select 1 from per_all_assignments_f paf2

819: And fnd_date.canonical_to_date(P_REPORT_DATE)
820: between ppf.effective_start_date and ppf.effective_end_date
821: And pps.actual_termination_date IS NOT NULL
822: And ppf.person_id = paf.person_id
823: And not exists (select 1 from per_all_assignments_f paf2
824: where ppf.person_id = paf2.person_id
825: and fnd_date.canonical_to_date(P_REPORT_DATE)
826: between paf2.effective_start_date and paf2.effective_end_date
827: )

Line 1182: ,per_all_assignments_f paf

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
1186: ,hr_organization_information hoi4

Line 1236: ,per_all_assignments_f paf

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
1240: ,hr_organization_information hoi4

Line 1252: And not exists (select 1 from per_all_assignments_f paf2

1248:
1249: And fnd_date.canonical_to_date(P_REPORT_DATE)
1250: between ppf.effective_start_date and ppf.effective_end_date
1251: And ppf.person_id = paf.person_id
1252: And not exists (select 1 from per_all_assignments_f paf2
1253: where ppf.person_id = paf2.person_id
1254: and fnd_date.canonical_to_date(P_REPORT_DATE)
1255: between paf2.effective_start_date and paf2.effective_end_date
1256: )

Line 1545: ,per_all_assignments_f paf

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
1549:

Line 1592: ,per_all_assignments_f paf

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
1596:

Line 1603: And not exists (select 1 from per_all_assignments_f paf2

1599:
1600: And fnd_date.canonical_to_date(P_REPORT_DATE)
1601: between ppf.effective_start_date and ppf.effective_end_date
1602: And ppf.person_id = paf.person_id
1603: And not exists (select 1 from per_all_assignments_f paf2
1604: where ppf.person_id = paf2.person_id
1605: and fnd_date.canonical_to_date(P_REPORT_DATE)
1606: between paf2.effective_start_date and paf2.effective_end_date
1607: )