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_PERSON_TYPES

Line 949: per_person_types ppt,

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
953: and ppt.system_person_type = 'EX_EMP'

Line 999: per_person_types ppt,

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
1003: and ppt.system_person_type = 'EX_EMP'

Line 1090: per_person_types ppt,

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
1094: and ppf.person_id = pps.person_id

Line 1217: per_person_types ppt,

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
1221: and ppf.person_id = pps.person_id

Line 1346: per_person_types ppt,

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
1350: and ppf.person_id = pps.person_id

Line 1462: per_person_types ppt,

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
1466: and ppf.person_id = pps.person_id

Line 1577: per_person_types ppt,

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
1581: and ppf.person_id = pps.person_id

Line 1985: per_person_types ppt,

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
1989: and ppt.system_person_type = 'EX_EMP'

Line 2035: per_person_types ppt,

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
2039: and ppt.system_person_type = 'EX_EMP'

Line 2140: per_person_types ppt,

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
2144: and ppf.person_id = pps.person_id

Line 2267: per_person_types ppt,

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
2271: and ppf.person_id = pps.person_id

Line 2396: per_person_types ppt,

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
2400: and ppf.person_id = pps.person_id

Line 2512: per_person_types ppt,

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
2516: and ppf.person_id = pps.person_id

Line 2627: per_person_types ppt,

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
2631: and ppf.person_id = pps.person_id