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 575: from dual

571:
572: cursor csr_org_hierarchy(p_organization_id ota_user_group_elements.organization_id%type,
573: p_org_structure_version_id ota_user_group_elements.org_structure_version_id%type) is
574: select p_organization_id as organization_id
575: from dual
576: union all
577: select x.sub_organization_id as organization_id
578: from per_org_hrchy_summary x,
579: per_org_structure_versions v,

Line 779: FROM dual

775: SELECT asg.assignment_id
776: FROM per_all_assignments_f asg,
777: (
778: SELECT p_organization_id AS organization_id
779: FROM dual
780: UNION ALL
781: SELECT x.sub_organization_id AS organization_id
782: FROM per_org_hrchy_summary x,
783: per_org_structure_versions v,

Line 2460: UNION ALL SELECT p_user_group_id FROM dual

2456: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2457: trunc(nvl(b.end_date_active, sysdate+1))
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:

Line 2480: UNION ALL SELECT p_user_group_id FROM dual

2476: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2477: trunc(nvl(b.end_date_active, sysdate+1))
2478: START WITH a.user_group_id = p_user_group_id
2479: CONNECT BY PRIOR a.child_user_group_id = a.user_group_id
2480: UNION ALL SELECT p_user_group_id FROM dual
2481: ) WHERE child_user_group_id is not null ) and
2482: e.person_id(+) = a.person_id and
2483: (e.effective_start_date is null or e.effective_start_date <= trunc(sysdate)) and
2484: (e.effective_end_date is null or trunc(sysdate) <= e.effective_end_date) and