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.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_PERSON_TYPES

Line 626: per_person_types ppt,

622: paf.business_group_id,
623: paf.assignment_id
624: FROM
625: per_all_assignments_f paf,
626: per_person_types ppt,
627: per_all_people_f perp,
628: per_person_type_usages_f ptu
629: WHERE
630: paf.person_id = l_person_id

Line 642: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

638: AND trunc(sysdate) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
639: AND ((ppt.system_person_type = 'APL'
640: AND NOT EXISTS (SELECT person_id
641: FROM per_person_type_usages_f ptf,
642: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
643: AND ptf.person_type_id = ptp.person_type_id
644: AND ptp.system_person_type IN ('EMP', 'CWK')
645: AND ptf.person_id = paf.PERSON_ID)
646: )OR ppt.system_person_type IN ('EMP', 'CWK'));

Line 719: per_person_types ppt,

715: paf.business_group_id,
716: paf.assignment_id
717: FROM
718: per_all_assignments_f paf,
719: per_person_types ppt,
720: per_all_people_f perp,
721: per_person_type_usages_f ptu
722: WHERE
723: paf.person_id = l_person_id

Line 735: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

731: AND trunc(sysdate) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
732: AND ((ppt.system_person_type = 'APL'
733: AND NOT EXISTS (SELECT person_id
734: FROM per_person_type_usages_f ptf,
735: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
736: AND ptf.person_type_id = ptp.person_type_id
737: AND ptp.system_person_type IN ('EMP', 'CWK')
738: AND ptf.person_id = paf.PERSON_ID)
739: )OR ppt.system_person_type IN ('EMP', 'CWK'));

Line 843: ,per_person_types pts

839: , paf.assignment_id
840: FROM per_all_people_f ppf
841: ,per_all_assignments_f paf
842: ,per_person_type_usages_f ptu
843: ,per_person_types pts
844: ,per_business_groups pbg
845: WHERE
846: paf.person_id = p_person_id
847: AND ppf.person_id = paf.person_id

Line 866: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

862: AND
863: ((pts.system_person_type = 'APL'
864: AND NOT EXISTS (SELECT person_id
865: FROM per_person_type_usages_f ptf,
866: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
867: AND ptf.person_type_id = ptp.person_type_id
868: AND ptp.system_person_type IN ('EMP', 'CWK')
869: AND ptf.person_id = ppf.PERSON_ID)
870: )

Line 902: ,per_person_types pts

898: ,per_all_assignments_f paf
899: ,per_jobs_tl pjt
900: ,per_all_positions pps
901: ,per_person_type_usages_f ptu
902: ,per_person_types pts
903: ,hr_all_organization_units_tl orgTl
904: ,per_business_groups pbg
905: WHERE ppf.person_id = paf.person_id
906: AND (pts.system_person_type IN ('EMP','CWK') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 929: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

925: AND
926: ((pts.system_person_type = 'APL'
927: AND NOT EXISTS (SELECT person_id
928: FROM per_person_type_usages_f ptf,
929: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
930: AND ptf.person_type_id = ptp.person_type_id
931: AND ptp.system_person_type IN ('EMP', 'CWK')
932: AND ptf.person_id = ppf.PERSON_ID)
933: )

Line 1025: ,per_person_types pts

1021: ,per_all_assignments_f paf
1022: ,per_jobs_tl pjt
1023: ,per_all_positions pps
1024: ,per_person_type_usages_f ptu
1025: ,per_person_types pts
1026: ,per_person_types_tl ptt
1027: ,hr_all_organization_units_tl orgTl
1028: ,per_business_groups pbg
1029: WHERE ppf.person_id = paf.person_id

Line 1026: ,per_person_types_tl ptt

1022: ,per_jobs_tl pjt
1023: ,per_all_positions pps
1024: ,per_person_type_usages_f ptu
1025: ,per_person_types pts
1026: ,per_person_types_tl ptt
1027: ,hr_all_organization_units_tl orgTl
1028: ,per_business_groups pbg
1029: WHERE ppf.person_id = paf.person_id
1030: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))

Line 1055: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

1051: AND
1052: ((pts.system_person_type = ''APL''
1053: AND NOT EXISTS (SELECT person_id
1054: FROM per_person_type_usages_f ptf,
1055: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
1056: AND ptf.person_type_id = ptp.person_type_id
1057: AND ptp.system_person_type IN (''EMP'', ''CWK'')
1058: AND ptf.person_id = ppf.PERSON_ID)
1059: )

Line 1226: ,per_person_types pts

1222: , paf.assignment_id
1223: FROM per_all_people_f ppf
1224: ,per_all_assignments_f paf
1225: ,per_person_type_usages_f ptu
1226: ,per_person_types pts
1227: ,per_business_groups pbg
1228: WHERE
1229: paf.person_id = p_person_id
1230: AND ppf.person_id = paf.person_id

Line 1249: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

1245: AND
1246: ((pts.system_person_type = 'APL'
1247: AND NOT EXISTS (SELECT person_id
1248: FROM per_person_type_usages_f ptf,
1249: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
1250: AND ptf.person_type_id = ptp.person_type_id
1251: AND ptp.system_person_type IN ('EMP', 'CWK')
1252: AND ptf.person_id = ppf.PERSON_ID)
1253: )

Line 1285: ,per_person_types pts

1281: ,per_all_assignments_f paf
1282: ,per_jobs_tl pjt
1283: ,per_all_positions pps
1284: ,per_person_type_usages_f ptu
1285: ,per_person_types pts
1286: ,hr_all_organization_units_tl orgTl
1287: ,per_business_groups pbg
1288: WHERE ppf.person_id = paf.person_id
1289: AND ((pts.system_person_type IN ('EMP','CWK') AND paf.primary_flag= 'Y') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 1312: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

1308: AND
1309: ((pts.system_person_type = 'APL'
1310: AND NOT EXISTS (SELECT person_id
1311: FROM per_person_type_usages_f ptf,
1312: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
1313: AND ptf.person_type_id = ptp.person_type_id
1314: AND ptp.system_person_type IN ('EMP', 'CWK')
1315: AND ptf.person_id = ppf.PERSON_ID)
1316: )

Line 1480: ,per_person_types pts

1476: ,per_all_assignments_f paf
1477: ,per_jobs_tl pjt
1478: ,per_all_positions pps
1479: ,per_person_type_usages_f ptu
1480: ,per_person_types pts
1481: ,per_person_types_tl ptt
1482: ,hr_all_organization_units_tl orgTl
1483: ,per_business_groups pbg
1484: WHERE ppf.person_id = paf.person_id

Line 1481: ,per_person_types_tl ptt

1477: ,per_jobs_tl pjt
1478: ,per_all_positions pps
1479: ,per_person_type_usages_f ptu
1480: ,per_person_types pts
1481: ,per_person_types_tl ptt
1482: ,hr_all_organization_units_tl orgTl
1483: ,per_business_groups pbg
1484: WHERE ppf.person_id = paf.person_id
1485: AND ((pts.system_person_type IN (''EMP'',''CWK'') AND paf.primary_flag = ''Y'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))

Line 1510: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

1506: AND
1507: ((pts.system_person_type = ''APL''
1508: AND NOT EXISTS (SELECT person_id
1509: FROM per_person_type_usages_f ptf,
1510: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
1511: AND ptf.person_type_id = ptp.person_type_id
1512: AND ptp.system_person_type IN (''EMP'', ''CWK'')
1513: AND ptf.person_id = ppf.PERSON_ID)
1514: )

Line 2418: ,per_person_types pts

2414: , paf.assignment_id
2415: FROM per_all_people_f ppf
2416: ,per_all_assignments_f paf
2417: ,per_person_type_usages_f ptu
2418: ,per_person_types pts
2419: ,per_business_groups pbg
2420: WHERE
2421: paf.person_id = p_person_id
2422: AND ppf.person_id = paf.person_id

Line 2436: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

2432: AND
2433: ((pts.system_person_type = 'APL'
2434: AND NOT EXISTS (SELECT person_id
2435: FROM per_person_type_usages_f ptf,
2436: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
2437: AND ptf.person_type_id = ptp.person_type_id
2438: AND ptp.system_person_type IN ('EMP', 'CWK')
2439: AND ptf.person_id = ppf.PERSON_ID)
2440: )

Line 2463: ,per_person_types pts

2459: ,per_all_assignments_f paf
2460: ,per_jobs_tl pjt
2461: ,per_all_positions pps
2462: ,per_person_type_usages_f ptu
2463: ,per_person_types pts
2464: ,hr_all_organization_units_tl orgTl
2465: ,per_business_groups pbg
2466: WHERE ppf.person_id = paf.person_id
2467: AND ((pts.system_person_type IN ('EMP','CWK') AND paf.primary_flag = 'Y') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))

Line 2486: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

2482: AND
2483: ((pts.system_person_type = 'APL'
2484: AND NOT EXISTS (SELECT person_id
2485: FROM per_person_type_usages_f ptf,
2486: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
2487: AND ptf.person_type_id = ptp.person_type_id
2488: AND ptp.system_person_type IN ('EMP', 'CWK')
2489: AND ptf.person_id = ppf.PERSON_ID)
2490: )

Line 2687: ,per_person_types pts

2683: ,per_all_assignments_f paf
2684: ,per_jobs_tl pjt
2685: ,per_all_positions pps
2686: ,per_person_type_usages_f ptu
2687: ,per_person_types pts
2688: ,per_person_types_tl ptt
2689: ,hr_all_organization_units_tl orgTl
2690: ,per_business_groups pbg
2691: WHERE ppf.person_id = paf.person_id

Line 2688: ,per_person_types_tl ptt

2684: ,per_jobs_tl pjt
2685: ,per_all_positions pps
2686: ,per_person_type_usages_f ptu
2687: ,per_person_types pts
2688: ,per_person_types_tl ptt
2689: ,hr_all_organization_units_tl orgTl
2690: ,per_business_groups pbg
2691: WHERE ppf.person_id = paf.person_id
2692: AND ((pts.system_person_type IN (''EMP'',''CWK'') AND paf.primary_flag = ''Y'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))

Line 2713: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

2709: AND
2710: ((pts.system_person_type = ''APL''
2711: AND NOT EXISTS (SELECT person_id
2712: FROM per_person_type_usages_f ptf,
2713: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
2714: AND ptf.person_type_id = ptp.person_type_id
2715: AND ptp.system_person_type IN (''EMP'', ''CWK'')
2716: AND ptf.person_id = ppf.PERSON_ID)
2717: )

Line 3028: per_person_types ppt,

3024: paf.business_group_id,
3025: paf.assignment_id
3026: FROM
3027: per_all_assignments_f paf,
3028: per_person_types ppt,
3029: per_all_people_f perp,
3030: per_person_type_usages_f ptu
3031: WHERE
3032: paf.person_id = l_person_id

Line 3044: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)

3040: AND trunc(sysdate) BETWEEN ptu.effective_start_date AND ptu.effective_end_date
3041: AND ((ppt.system_person_type = 'APL'
3042: AND NOT EXISTS (SELECT person_id
3043: FROM per_person_type_usages_f ptf,
3044: per_person_types ptp WHERE trunc(sysdate) BETWEEN trunc(ptf.effective_start_date) AND trunc(ptf.effective_end_date)
3045: AND ptf.person_type_id = ptp.person_type_id
3046: AND ptp.system_person_type IN ('EMP', 'CWK')
3047: AND ptf.person_id = paf.PERSON_ID)
3048: )OR ppt.system_person_type IN ('EMP', 'CWK'));