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 948: from per_all_people_f ppf,

944: )
945: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
946: and not exists
947: ( select 1
948: from per_all_people_f ppf,
949: per_person_types ppt,
950: per_periods_of_service pps
951: where ppf.person_id = pps.person_id
952: and ppt.person_type_id = ppf.person_type_id

Line 998: from per_all_people_f ppf,

994: )
995: /* Do not retrieve employees whose final process dates have passed */
996: and not exists
997: ( select 1
998: from per_all_people_f ppf,
999: per_person_types ppt,
1000: per_periods_of_service pps
1001: where ppf.person_id = pps.person_id
1002: and ppt.person_type_id = ppf.person_type_id

Line 1014: from per_all_people_f ppf,

1010: and pps.date_start <= paa.date_start)
1011: /* Do not retrieve employees who are deceased */
1012: and not exists
1013: ( select 1
1014: from per_all_people_f ppf,
1015: per_periods_of_service pps
1016: where ppf.person_id = pps.person_id
1017: and pps.leaving_reason = 'D'
1018: and ppf.person_id = paa.person_id)

Line 1089: per_all_people_f ppf,

1085: and peev3.element_entry_id in
1086: ( select peef1.element_entry_id
1087: from pay_element_entries_f peef1,
1088: per_all_assignments_f paf,
1089: per_all_people_f ppf,
1090: per_person_types ppt,
1091: per_periods_of_service pps
1092: where peef1.assignment_id = paf.assignment_id
1093: and paf.person_id = ppf.person_id

Line 1216: per_all_people_f ppf,

1212: -- Retrieve only those entries that main SMP query will retrieve
1213: and exists
1214: ( select 1
1215: from per_all_assignments_f paf,
1216: per_all_people_f ppf,
1217: per_person_types ppt,
1218: per_periods_of_service pps
1219: where peef.assignment_id = paf.assignment_id
1220: and paf.person_id = ppf.person_id

Line 1345: per_all_people_f ppf,

1341: -- Retrieve only those entries that main sap query will retrieve
1342: and exists
1343: ( select 1
1344: from per_all_assignments_f paf,
1345: per_all_people_f ppf,
1346: per_person_types ppt,
1347: per_periods_of_service pps
1348: where peef.assignment_id = paf.assignment_id
1349: and paf.person_id = ppf.person_id

Line 1461: per_all_people_f ppf,

1457: -- Retrieve only those entries that main sppa query will retrieve
1458: and exists
1459: ( select 1
1460: from per_all_assignments_f paf,
1461: per_all_people_f ppf,
1462: per_person_types ppt,
1463: per_periods_of_service pps
1464: where peef.assignment_id = paf.assignment_id
1465: and paf.person_id = ppf.person_id

Line 1576: per_all_people_f ppf,

1572: -- Retrieve only those entries that main SPPB query will retrieve
1573: and exists
1574: ( select 1
1575: from per_all_assignments_f paf,
1576: per_all_people_f ppf,
1577: per_person_types ppt,
1578: per_periods_of_service pps
1579: where peef.assignment_id = paf.assignment_id
1580: and paf.person_id = ppf.person_id

Line 1984: from per_all_people_f ppf,

1980: )
1981: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
1982: and not exists
1983: ( select 1
1984: from per_all_people_f ppf,
1985: per_person_types ppt,
1986: per_periods_of_service pps
1987: where ppf.person_id = pps.person_id
1988: and ppt.person_type_id = ppf.person_type_id

Line 2034: from per_all_people_f ppf,

2030: )
2031: /* Do not retrieve employees whose final process dates have passed */
2032: and not exists
2033: ( select 1
2034: from per_all_people_f ppf,
2035: per_person_types ppt,
2036: per_periods_of_service pps
2037: where ppf.person_id = pps.person_id
2038: and ppt.person_type_id = ppf.person_type_id

Line 2050: from per_all_people_f ppf,

2046: and pps.date_start <= paa.date_start)
2047: /* Do not retrieve employees who are deceased */
2048: and not exists
2049: ( select 1
2050: from per_all_people_f ppf,
2051: per_periods_of_service pps
2052: where ppf.person_id = pps.person_id
2053: and pps.leaving_reason = 'D'
2054: and ppf.person_id = paa.person_id)

Line 2139: per_all_people_f ppf,

2135: and peev3.element_entry_id in
2136: ( select peef1.element_entry_id
2137: from pay_element_entries_f peef1,
2138: per_all_assignments_f paf,
2139: per_all_people_f ppf,
2140: per_person_types ppt,
2141: per_periods_of_service pps
2142: where peef1.assignment_id = paf.assignment_id
2143: and paf.person_id = ppf.person_id

Line 2266: per_all_people_f ppf,

2262: -- Retrieve only those entries that main SMP query will retrieve
2263: and exists
2264: ( select 1
2265: from per_all_assignments_f paf,
2266: per_all_people_f ppf,
2267: per_person_types ppt,
2268: per_periods_of_service pps
2269: where peef.assignment_id = paf.assignment_id
2270: and paf.person_id = ppf.person_id

Line 2395: per_all_people_f ppf,

2391: -- Retrieve only those entries that main sap query will retrieve
2392: and exists
2393: ( select 1
2394: from per_all_assignments_f paf,
2395: per_all_people_f ppf,
2396: per_person_types ppt,
2397: per_periods_of_service pps
2398: where peef.assignment_id = paf.assignment_id
2399: and paf.person_id = ppf.person_id

Line 2511: per_all_people_f ppf,

2507: -- Retrieve only those entries that main sppa query will retrieve
2508: and exists
2509: ( select 1
2510: from per_all_assignments_f paf,
2511: per_all_people_f ppf,
2512: per_person_types ppt,
2513: per_periods_of_service pps
2514: where peef.assignment_id = paf.assignment_id
2515: and paf.person_id = ppf.person_id

Line 2626: per_all_people_f ppf,

2622: -- Retrieve only those entries that main SPPB query will retrieve
2623: and exists
2624: ( select 1
2625: from per_all_assignments_f paf,
2626: per_all_people_f ppf,
2627: per_person_types ppt,
2628: per_periods_of_service pps
2629: where peef.assignment_id = paf.assignment_id
2630: and paf.person_id = ppf.person_id