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_TYPE_USAGES_F

Line 628: per_person_type_usages_f ptu

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
631: AND perp.person_id =paf.person_id
632: AND perp.person_id = ptu.person_id

Line 641: FROM per_person_type_usages_f ptf,

637: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.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)

Line 721: per_person_type_usages_f ptu

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
724: AND perp.person_id =paf.person_id
725: AND perp.person_id = ptu.person_id

Line 734: FROM per_person_type_usages_f ptf,

730: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.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)

Line 842: ,per_person_type_usages_f ptu

838: , paf.organization_id
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

Line 865: FROM per_person_type_usages_f ptf,

861: AND paf.business_group_id = pbg.business_group_id
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)

Line 901: ,per_person_type_usages_f ptu

897: FROM per_all_people_f ppf
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

Line 928: FROM per_person_type_usages_f ptf,

924: AND paf.business_group_id = pbg.business_group_id
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)

Line 1024: ,per_person_type_usages_f ptu

1020: FROM per_all_people_f ppf
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

Line 1054: FROM per_person_type_usages_f ptf,

1050: AND paf.business_group_id = pbg.business_group_id
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)

Line 1225: ,per_person_type_usages_f ptu

1221: , paf.organization_id
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

Line 1248: FROM per_person_type_usages_f ptf,

1244: AND paf.business_group_id = pbg.business_group_id
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)

Line 1284: ,per_person_type_usages_f ptu

1280: FROM per_all_people_f ppf
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

Line 1311: FROM per_person_type_usages_f ptf,

1307: AND paf.business_group_id = pbg.business_group_id
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)

Line 1479: ,per_person_type_usages_f ptu

1475: FROM per_all_people_f ppf
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

Line 1509: FROM per_person_type_usages_f ptf,

1505: AND paf.business_group_id = pbg.business_group_id
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)

Line 2417: ,per_person_type_usages_f ptu

2413: , paf.organization_id
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

Line 2435: FROM per_person_type_usages_f ptf,

2431: AND paf.business_group_id = pbg.business_group_id
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)

Line 2462: ,per_person_type_usages_f ptu

2458: FROM per_all_people_f ppf
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

Line 2485: FROM per_person_type_usages_f ptf,

2481: AND paf.business_group_id = pbg.business_group_id
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)

Line 2686: ,per_person_type_usages_f ptu

2682: FROM per_all_people_f ppf
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

Line 2712: FROM per_person_type_usages_f ptf,

2708: AND paf.business_group_id = pbg.business_group_id
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)

Line 3030: per_person_type_usages_f ptu

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
3033: AND perp.person_id =paf.person_id
3034: AND perp.person_id = ptu.person_id

Line 3043: FROM per_person_type_usages_f ptf,

3039: AND trunc(sysdate) BETWEEN paf.effective_start_date AND paf.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)