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 HR_ALL_ORGANIZATION_UNITS_TL

Line 903: ,hr_all_organization_units_tl orgTl

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'))
907: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 1027: ,hr_all_organization_units_tl orgTl

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''))
1031: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 1286: ,hr_all_organization_units_tl orgTl

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'))
1290: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 1482: ,hr_all_organization_units_tl orgTl

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''))
1486: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 2464: ,hr_all_organization_units_tl orgTl

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'))
2468: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 2689: ,hr_all_organization_units_tl orgTl

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''))
2693: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date