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_LEARNER_ACCESS_UTIL dependencies on FND_PROFILE

Line 147: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

143: where ea.event_id = p_event_id
144: and paf.person_id = p_person_id
145: AND nvl(ea.mandatory_enrollment_flag,'N') = 'Y'
146: AND paf.assignment_type in ('E','A','C')
147: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
148: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
149: OR nvl(p_as_of, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
150: AND nvl(ea.job_id, -1) = decode(ea.job_id, null, -1, paf.job_id)
151: AND nvl(ea.position_id,-1) = decode(ea.position_id, null, -1,paf.position_id)

Line 172: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

168: where ea.event_id = p_event_id
169: and paf.person_id = p_person_id
170: AND nvl(ea.mandatory_enrollment_flag,'N') = 'Y'
171: AND paf.assignment_type in ('E','A','C')
172: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
173: AND trunc(sysdate) BETWEEN paf.effective_start_date and paf.effective_end_date)
174: OR nvl(p_as_of, trunc(sysdate)) between paf.effective_start_date and paf.effective_end_date )
175: AND ((ea.user_group_id is null
176: AND nvl(ea.job_id, -1) = decode(ea.job_id, null, -1, paf.job_id)

Line 398: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

394: p_as_of date) is
395: select asg.assignment_id
396: from per_all_assignments_f asg
397: where asg.person_id = p_person_id
398: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
399: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
400: OR nvl(p_as_of, trunc(sysdate)) between asg.effective_start_date and asg.effective_end_date )
401: and
402: nvl(p_organization_id, -1) = decode(p_organization_id, null, -1, nvl(asg.organization_id,-1)) and

Line 435: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

431: x.organization_id = p_organization_id and
432: x.sub_org_relative_level > 0
433: ) orgs
434: where asg.person_id = p_person_id
435: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
436: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
437: OR nvl(p_as_of, trunc(sysdate)) between asg.effective_start_date and asg.effective_end_date )
438: AND nvl(p_as_of, trunc(sysdate)) between asg.effective_start_date and asg.effective_end_date and
439: asg.organization_id = orgs.organization_id and

Line 461: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

457: and perp.person_id =ptu.person_id
458: and ptu.person_type_id=ppt.person_type_id
459: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
460: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
461: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
462: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
463: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
464: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
465: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)

Line 464: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

460: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
461: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
462: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
463: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
464: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
465: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)
466: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between perp.effective_start_date and perp.effective_end_date )
467: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
468: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 467: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

463: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
464: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
465: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)
466: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between perp.effective_start_date and perp.effective_end_date )
467: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
468: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
469: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between ptu.effective_start_date and ptu.effective_end_date )
470: and
471: nvl(p_organization_id, -1) = decode(p_organization_id, null, -1, nvl(asg.organization_id,-1)) and

Line 514: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

510: and perp.person_id =ptu.person_id
511: and ptu.person_type_id=ppt.person_type_id
512: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
513: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
514: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
515: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
516: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
517: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
518: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)

Line 517: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

513: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
514: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
515: AND trunc(sysdate) BETWEEN asg.effective_start_date and asg.effective_end_date)
516: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
517: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
518: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)
519: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between perp.effective_start_date and perp.effective_end_date )
520: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
521: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)

Line 520: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

516: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between asg.effective_start_date and asg.effective_end_date )
517: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
518: AND trunc(sysdate) BETWEEN perp.effective_start_date and perp.effective_end_date)
519: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between perp.effective_start_date and perp.effective_end_date )
520: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'
521: AND trunc(sysdate) BETWEEN ptu.effective_start_date and ptu.effective_end_date)
522: OR decode(p_as_of,NULL, trunc(sysdate),trunc(p_as_of)) between ptu.effective_start_date and ptu.effective_end_date )
523: -- AND nvl(p_as_of, trunc(sysdate)) between asg.effective_start_date and asg.effective_end_date and
524: and asg.organization_id = orgs.organization_id and

Line 2462: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null

2458: START WITH a.user_group_id = p_user_group_id
2459: CONNECT BY PRIOR a.child_user_group_id = a.user_group_id
2460: UNION ALL SELECT p_user_group_id FROM dual
2461: ) WHERE child_user_group_id is not null ) and
2462: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null
2463: or business_group_id = p_business_group_id);
2464:
2465: SELECT count(a.user_group_element_id) into restricted_elements_count
2466: FROM OTA_USER_GROUP_ELEMENTS a,

Line 2488: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or

2484: (e.effective_end_date is null or trunc(sysdate) <= e.effective_end_date) and
2485: job.job_id(+) = a.job_id and
2486: org.organization_id(+) = a.organization_id and
2487: pos.position_id(+) = a.position_id and
2488: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null or
2489: a.business_group_id = p_business_group_id) and
2490: -- decode (a.position_id, null, -1, pos.organization_id) = nvl(org.organization_id,-1) and --7157831
2491: decode (a.position_id, null, -1, pos.organization_id) = decode(a.position_id, null, -1, org.organization_id) and --7248298
2492: (e.person_id is not null or job.job_id is not null or pos.position_id is not null or