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_BUSINESS_GROUPS

Line 844: ,per_business_groups pbg

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
848: 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 904: ,per_business_groups pbg

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
908: AND((p_future_enddated_prof_val = 'Y'

Line 1028: ,per_business_groups pbg

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
1032: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

Line 1227: ,per_business_groups pbg

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
1231: 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 1287: ,per_business_groups pbg

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
1291: AND((p_future_enddated_prof_val = 'Y'

Line 1483: ,per_business_groups pbg

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
1487: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''

Line 2419: ,per_business_groups pbg

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
2423: 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 2465: ,per_business_groups pbg

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

Line 2690: ,per_business_groups pbg

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