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 DUAL

Line 419: from dual

415: select asg.assignment_id
416: from per_all_assignments_f asg,
417: (
418: select p_organization_id as organization_id
419: from dual
420: union all
421: select x.sub_organization_id as organization_id
422: from per_org_hrchy_summary x,
423: per_org_structure_versions v,

Line 490: from dual

486: select asg.assignment_id
487: from per_all_assignments_f asg,
488: (
489: select p_organization_id as organization_id
490: from dual
491: union all
492: select x.sub_organization_id as organization_id
493: from per_org_hrchy_summary x,
494: per_org_structure_versions v,

Line 552: from dual

548:
549: cursor csr_org_hierarchy(p_organization_id ota_user_group_elements.organization_id%type,
550: p_org_structure_version_id ota_user_group_elements.org_structure_version_id%type) is
551: select p_organization_id as organization_id
552: from dual
553: union all
554: select x.sub_organization_id as organization_id
555: from per_org_hrchy_summary x,
556: per_org_structure_versions v,

Line 761: FROM dual

757: SELECT asg.assignment_id
758: FROM per_all_assignments_f asg,
759: (
760: SELECT p_organization_id AS organization_id
761: FROM dual
762: UNION ALL
763: SELECT x.sub_organization_id AS organization_id
764: FROM per_org_hrchy_summary x,
765: per_org_structure_versions v,

Line 2594: UNION ALL SELECT p_user_group_id FROM dual

2590: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2591: trunc(nvl(b.end_date_active, sysdate+1))
2592: START WITH a.user_group_id = p_user_group_id
2593: CONNECT BY PRIOR a.child_user_group_id = a.user_group_id
2594: UNION ALL SELECT p_user_group_id FROM dual
2595: ) WHERE child_user_group_id is not null ) and
2596: (fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null
2597: or business_group_id = p_business_group_id)
2598: and( person_id is null or elig_prfl_id is null);

Line 2616: UNION ALL SELECT p_user_group_id FROM dual

2612: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2613: trunc(nvl(b.end_date_active, sysdate+1))
2614: START WITH a.user_group_id = p_user_group_id
2615: CONNECT BY PRIOR a.child_user_group_id = a.user_group_id
2616: UNION ALL SELECT p_user_group_id FROM dual
2617: ) WHERE child_user_group_id is not null ) and
2618: e.person_id(+) = a.person_id and
2619: (e.effective_start_date is null or e.effective_start_date <= trunc(sysdate)) and
2620: (e.effective_end_date is null or trunc(sysdate) <= e.effective_end_date) and