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.SSP_SMP_SUPPORT_PKG dependencies on PER_ALL_PEOPLE_F

Line 993: from per_all_people_f ppf,

989: )
990: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
991: and not exists
992: ( select 1
993: from per_all_people_f ppf,
994: per_person_types ppt,
995: per_periods_of_service pps
996: where ppf.person_id = pps.person_id
997: and ppt.person_type_id = ppf.person_type_id

Line 1043: from per_all_people_f ppf,

1039: )
1040: /* Do not retrieve employees whose final process dates have passed */
1041: and not exists
1042: ( select 1
1043: from per_all_people_f ppf,
1044: per_person_types ppt,
1045: per_periods_of_service pps
1046: where ppf.person_id = pps.person_id
1047: and ppt.person_type_id = ppf.person_type_id

Line 1059: from per_all_people_f ppf,

1055: and pps.date_start <= paa.date_start)
1056: /* Do not retrieve employees who are deceased */
1057: and not exists
1058: ( select 1
1059: from per_all_people_f ppf,
1060: per_periods_of_service pps
1061: where ppf.person_id = pps.person_id
1062: and pps.leaving_reason = 'D'
1063: and ppf.person_id = paa.person_id)

Line 1142: per_all_people_f ppf,

1138: and peev3.element_entry_id in
1139: ( select peef1.element_entry_id
1140: from pay_element_entries_f peef1,
1141: per_all_assignments_f paf,
1142: per_all_people_f ppf,
1143: per_person_types ppt,
1144: per_periods_of_service pps
1145: where peef1.assignment_id = paf.assignment_id
1146: and paf.person_id = ppf.person_id

Line 1269: per_all_people_f ppf,

1265: -- Retrieve only those entries that main SMP query will retrieve
1266: and exists
1267: ( select 1
1268: from per_all_assignments_f paf,
1269: per_all_people_f ppf,
1270: per_person_types ppt,
1271: per_periods_of_service pps
1272: where peef.assignment_id = paf.assignment_id
1273: and paf.person_id = ppf.person_id

Line 1398: per_all_people_f ppf,

1394: -- Retrieve only those entries that main sap query will retrieve
1395: and exists
1396: ( select 1
1397: from per_all_assignments_f paf,
1398: per_all_people_f ppf,
1399: per_person_types ppt,
1400: per_periods_of_service pps
1401: where peef.assignment_id = paf.assignment_id
1402: and paf.person_id = ppf.person_id

Line 1514: per_all_people_f ppf,

1510: -- Retrieve only those entries that main sppa query will retrieve
1511: and exists
1512: ( select 1
1513: from per_all_assignments_f paf,
1514: per_all_people_f ppf,
1515: per_person_types ppt,
1516: per_periods_of_service pps
1517: where peef.assignment_id = paf.assignment_id
1518: and paf.person_id = ppf.person_id

Line 1629: per_all_people_f ppf,

1625: -- Retrieve only those entries that main SPPB query will retrieve
1626: and exists
1627: ( select 1
1628: from per_all_assignments_f paf,
1629: per_all_people_f ppf,
1630: per_person_types ppt,
1631: per_periods_of_service pps
1632: where peef.assignment_id = paf.assignment_id
1633: and paf.person_id = ppf.person_id

Line 2281: from per_all_people_f ppf,

2277: )
2278: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
2279: and not exists
2280: ( select 1
2281: from per_all_people_f ppf,
2282: per_person_types ppt,
2283: per_periods_of_service pps
2284: where ppf.person_id = pps.person_id
2285: and ppt.person_type_id = ppf.person_type_id

Line 2331: from per_all_people_f ppf,

2327: )
2328: /* Do not retrieve employees whose final process dates have passed */
2329: and not exists
2330: ( select 1
2331: from per_all_people_f ppf,
2332: per_person_types ppt,
2333: per_periods_of_service pps
2334: where ppf.person_id = pps.person_id
2335: and ppt.person_type_id = ppf.person_type_id

Line 2347: from per_all_people_f ppf,

2343: and pps.date_start <= paa.date_start)
2344: /* Do not retrieve employees who are deceased */
2345: and not exists
2346: ( select 1
2347: from per_all_people_f ppf,
2348: per_periods_of_service pps
2349: where ppf.person_id = pps.person_id
2350: and pps.leaving_reason = 'D'
2351: and ppf.person_id = paa.person_id)

Line 2443: per_all_people_f ppf,

2439: and peev3.element_entry_id in
2440: ( select peef1.element_entry_id
2441: from pay_element_entries_f peef1,
2442: per_all_assignments_f paf,
2443: per_all_people_f ppf,
2444: per_person_types ppt,
2445: per_periods_of_service pps
2446: where peef1.assignment_id = paf.assignment_id
2447: and paf.person_id = ppf.person_id

Line 2570: per_all_people_f ppf,

2566: -- Retrieve only those entries that main SMP query will retrieve
2567: and exists
2568: ( select 1
2569: from per_all_assignments_f paf,
2570: per_all_people_f ppf,
2571: per_person_types ppt,
2572: per_periods_of_service pps
2573: where peef.assignment_id = paf.assignment_id
2574: and paf.person_id = ppf.person_id

Line 2699: per_all_people_f ppf,

2695: -- Retrieve only those entries that main sap query will retrieve
2696: and exists
2697: ( select 1
2698: from per_all_assignments_f paf,
2699: per_all_people_f ppf,
2700: per_person_types ppt,
2701: per_periods_of_service pps
2702: where peef.assignment_id = paf.assignment_id
2703: and paf.person_id = ppf.person_id

Line 2815: per_all_people_f ppf,

2811: -- Retrieve only those entries that main sppa query will retrieve
2812: and exists
2813: ( select 1
2814: from per_all_assignments_f paf,
2815: per_all_people_f ppf,
2816: per_person_types ppt,
2817: per_periods_of_service pps
2818: where peef.assignment_id = paf.assignment_id
2819: and paf.person_id = ppf.person_id

Line 2930: per_all_people_f ppf,

2926: -- Retrieve only those entries that main SPPB query will retrieve
2927: and exists
2928: ( select 1
2929: from per_all_assignments_f paf,
2930: per_all_people_f ppf,
2931: per_person_types ppt,
2932: per_periods_of_service pps
2933: where peef.assignment_id = paf.assignment_id
2934: and paf.person_id = ppf.person_id