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_PERIODS_OF_SERVICE

Line 950: per_periods_of_service pps

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'
954: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate

Line 957: from per_periods_of_service pos

953: and ppt.system_person_type = 'EX_EMP'
954: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate
955: and ppf.person_id = paa.person_id
956: and pps.date_start = (select max(date_start)
957: from per_periods_of_service pos
958: where pos.person_id = pps.person_id)
959: and ppf.effective_start_date >= pps.date_start
960: and pps.date_start <= paa.sickness_start_date)
961: order by nvl(paa.linked_absence_id,paa.absence_attendance_id);

Line 1000: per_periods_of_service pps

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'
1004: and pps.final_process_date <= sysdate

Line 1007: from per_periods_of_service pos

1003: and ppt.system_person_type = 'EX_EMP'
1004: and pps.final_process_date <= sysdate
1005: and ppf.person_id = paa.person_id
1006: and pps.date_start = (select max(date_start)
1007: from per_periods_of_service pos
1008: where pos.person_id = pps.person_id)
1009: and ppf.effective_start_date >= pps.date_start
1010: and pps.date_start <= paa.date_start)
1011: /* Do not retrieve employees who are deceased */

Line 1015: per_periods_of_service pps

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)
1019: order by paa.maternity_id;

Line 1091: per_periods_of_service pps

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
1095: and ppt.person_type_id = ppf.person_type_id

Line 1218: per_periods_of_service pps

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
1222: and ppt.person_type_id = ppf.person_type_id

Line 1347: per_periods_of_service pps

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
1351: and ppt.person_type_id = ppf.person_type_id

Line 1463: per_periods_of_service pps

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
1467: and ppt.person_type_id = ppf.person_type_id

Line 1578: per_periods_of_service pps

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
1582: and ppt.person_type_id = ppf.person_type_id

Line 1986: per_periods_of_service pps

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'
1990: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate

Line 1993: from per_periods_of_service pos

1989: and ppt.system_person_type = 'EX_EMP'
1990: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate
1991: and ppf.person_id = paa.person_id
1992: and pps.date_start = (select max(date_start)
1993: from per_periods_of_service pos
1994: where pos.person_id = pps.person_id)
1995: and ppf.effective_start_date >= pps.date_start
1996: and pps.date_start <= paa.sickness_start_date)
1997: order by nvl(paa.linked_absence_id,paa.absence_attendance_id);

Line 2036: per_periods_of_service pps

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'
2040: and pps.final_process_date <= sysdate

Line 2043: from per_periods_of_service pos

2039: and ppt.system_person_type = 'EX_EMP'
2040: and pps.final_process_date <= sysdate
2041: and ppf.person_id = paa.person_id
2042: and pps.date_start = (select max(date_start)
2043: from per_periods_of_service pos
2044: where pos.person_id = pps.person_id)
2045: and ppf.effective_start_date >= pps.date_start
2046: and pps.date_start <= paa.date_start)
2047: /* Do not retrieve employees who are deceased */

Line 2051: per_periods_of_service pps

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)
2055: order by paa.maternity_id;

Line 2141: per_periods_of_service pps

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
2145: and ppt.person_type_id = ppf.person_type_id

Line 2268: per_periods_of_service pps

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
2272: and ppt.person_type_id = ppf.person_type_id

Line 2397: per_periods_of_service pps

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
2401: and ppt.person_type_id = ppf.person_type_id

Line 2513: per_periods_of_service pps

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
2517: and ppt.person_type_id = ppf.person_type_id

Line 2628: per_periods_of_service pps

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
2632: and ppt.person_type_id = ppf.person_type_id