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 994: per_person_types ppt,

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

Line 1044: per_person_types ppt,

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

Line 1143: per_person_types ppt,

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

Line 1270: per_person_types ppt,

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

Line 1399: per_person_types ppt,

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

Line 1515: per_person_types ppt,

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

Line 1630: per_person_types ppt,

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

Line 2282: per_person_types ppt,

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

Line 2332: per_person_types ppt,

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

Line 2444: per_person_types ppt,

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

Line 2571: per_person_types ppt,

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

Line 2700: per_person_types ppt,

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

Line 2816: per_person_types ppt,

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

Line 2931: per_person_types ppt,

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