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 995: per_periods_of_service pps

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

Line 1002: from per_periods_of_service pos

998: and ppt.system_person_type = 'EX_EMP'
999: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate
1000: and ppf.person_id = paa.person_id
1001: and pps.date_start = (select max(date_start)
1002: from per_periods_of_service pos
1003: where pos.person_id = pps.person_id)
1004: and ppf.effective_start_date >= pps.date_start
1005: and pps.date_start <= paa.sickness_start_date)
1006: order by nvl(paa.linked_absence_id,paa.absence_attendance_id);

Line 1045: per_periods_of_service pps

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
1048: and ppt.system_person_type = 'EX_EMP'
1049: and pps.final_process_date <= sysdate

Line 1052: from per_periods_of_service pos

1048: and ppt.system_person_type = 'EX_EMP'
1049: and pps.final_process_date <= sysdate
1050: and ppf.person_id = paa.person_id
1051: and pps.date_start = (select max(date_start)
1052: from per_periods_of_service pos
1053: where pos.person_id = pps.person_id)
1054: and ppf.effective_start_date >= pps.date_start
1055: and pps.date_start <= paa.date_start)
1056: /* Do not retrieve employees who are deceased */

Line 1060: per_periods_of_service pps

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

Line 1144: per_periods_of_service pps

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
1147: and ppf.person_id = pps.person_id
1148: and ppt.person_type_id = ppf.person_type_id

Line 1271: per_periods_of_service pps

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
1274: and ppf.person_id = pps.person_id
1275: and ppt.person_type_id = ppf.person_type_id

Line 1400: per_periods_of_service pps

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
1403: and ppf.person_id = pps.person_id
1404: and ppt.person_type_id = ppf.person_type_id

Line 1516: per_periods_of_service pps

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
1519: and ppf.person_id = pps.person_id
1520: and ppt.person_type_id = ppf.person_type_id

Line 1631: per_periods_of_service pps

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
1634: and ppf.person_id = pps.person_id
1635: and ppt.person_type_id = ppf.person_type_id

Line 2283: per_periods_of_service pps

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

Line 2290: from per_periods_of_service pos

2286: and ppt.system_person_type = 'EX_EMP'
2287: and nvl(pps.actual_termination_date,to_date('01/01/0001','DD/MM/YYYY')) <= sysdate
2288: and ppf.person_id = paa.person_id
2289: and pps.date_start = (select max(date_start)
2290: from per_periods_of_service pos
2291: where pos.person_id = pps.person_id)
2292: and ppf.effective_start_date >= pps.date_start
2293: and pps.date_start <= paa.sickness_start_date)
2294: order by nvl(paa.linked_absence_id,paa.absence_attendance_id);

Line 2333: per_periods_of_service pps

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
2336: and ppt.system_person_type = 'EX_EMP'
2337: and pps.final_process_date <= sysdate

Line 2340: from per_periods_of_service pos

2336: and ppt.system_person_type = 'EX_EMP'
2337: and pps.final_process_date <= sysdate
2338: and ppf.person_id = paa.person_id
2339: and pps.date_start = (select max(date_start)
2340: from per_periods_of_service pos
2341: where pos.person_id = pps.person_id)
2342: and ppf.effective_start_date >= pps.date_start
2343: and pps.date_start <= paa.date_start)
2344: /* Do not retrieve employees who are deceased */

Line 2348: per_periods_of_service pps

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

Line 2445: per_periods_of_service pps

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
2448: and ppf.person_id = pps.person_id
2449: and ppt.person_type_id = ppf.person_type_id

Line 2572: per_periods_of_service pps

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
2575: and ppf.person_id = pps.person_id
2576: and ppt.person_type_id = ppf.person_type_id

Line 2701: per_periods_of_service pps

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
2704: and ppf.person_id = pps.person_id
2705: and ppt.person_type_id = ppf.person_type_id

Line 2817: per_periods_of_service pps

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
2820: and ppf.person_id = pps.person_id
2821: and ppt.person_type_id = ppf.person_type_id

Line 2932: per_periods_of_service pps

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
2935: and ppf.person_id = pps.person_id
2936: and ppt.person_type_id = ppf.person_type_id