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 762: ,per_all_assignments_f paf

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
765: ,hr_organization_information hoi3
766: ,hr_organization_information hoi2

Line 817: ,per_all_assignments_f paf

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
820: ,hr_organization_information hoi3
821: ,hr_organization_information hoi2

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

827: And fnd_date.canonical_to_date(P_REPORT_DATE)
828: between ppf.effective_start_date and ppf.effective_end_date
829: And pps.actual_termination_date IS NOT NULL
830: And ppf.person_id = paf.person_id
831: And not exists (select 1 from per_all_assignments_f paf2
832: where ppf.person_id = paf2.person_id
833: and fnd_date.canonical_to_date(P_REPORT_DATE)
834: between paf2.effective_start_date and paf2.effective_end_date
835: )

Line 1190: ,per_all_assignments_f paf

1186: count(ppf.person_id)
1187:
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

Line 1244: ,per_all_assignments_f paf

1240: count(ppf.person_id)
1241:
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

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

1256:
1257: And fnd_date.canonical_to_date(P_REPORT_DATE)
1258: between ppf.effective_start_date and ppf.effective_end_date
1259: And ppf.person_id = paf.person_id
1260: And not exists (select 1 from per_all_assignments_f paf2
1261: where ppf.person_id = paf2.person_id
1262: and fnd_date.canonical_to_date(P_REPORT_DATE)
1263: between paf2.effective_start_date and paf2.effective_end_date
1264: )

Line 1553: ,per_all_assignments_f paf

1549: ,hl.region_2 STATE
1550:
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:

Line 1600: ,per_all_assignments_f paf

1596: ,hl.region_2 STATE
1597:
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:

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

1607:
1608: And fnd_date.canonical_to_date(P_REPORT_DATE)
1609: between ppf.effective_start_date and ppf.effective_end_date
1610: And ppf.person_id = paf.person_id
1611: And not exists (select 1 from per_all_assignments_f paf2
1612: where ppf.person_id = paf2.person_id
1613: and fnd_date.canonical_to_date(P_REPORT_DATE)
1614: between paf2.effective_start_date and paf2.effective_end_date
1615: )