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 PER_ORG_STRUCTURE_VERSIONS

Line 423: per_org_structure_versions v,

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,
424: per_org_structure_versions currv
425: where v.org_structure_version_id = p_org_structure_version_id and
426: v.organization_structure_id = currv.organization_structure_id and
427: (currv.date_to is null or

Line 424: per_org_structure_versions currv

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,
424: per_org_structure_versions currv
425: where v.org_structure_version_id = p_org_structure_version_id and
426: v.organization_structure_id = currv.organization_structure_id and
427: (currv.date_to is null or
428: sysdate between currv.date_from and currv.date_to) and

Line 494: per_org_structure_versions v,

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,
495: per_org_structure_versions currv
496: where v.org_structure_version_id = p_org_structure_version_id and
497: v.organization_structure_id = currv.organization_structure_id and
498: (currv.date_to is null or

Line 495: per_org_structure_versions currv

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,
495: per_org_structure_versions currv
496: where v.org_structure_version_id = p_org_structure_version_id and
497: v.organization_structure_id = currv.organization_structure_id and
498: (currv.date_to is null or
499: sysdate between currv.date_from and currv.date_to) and

Line 579: per_org_structure_versions v,

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,
580: per_org_structure_versions currv
581: where v.org_structure_version_id = p_org_structure_version_id and
582: v.organization_structure_id = currv.organization_structure_id and
583: (currv.date_to is null or sysdate between currv.date_from and currv.date_to) and

Line 580: per_org_structure_versions currv

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,
580: per_org_structure_versions currv
581: where v.org_structure_version_id = p_org_structure_version_id and
582: v.organization_structure_id = currv.organization_structure_id and
583: (currv.date_to is null or sysdate between currv.date_from and currv.date_to) and
584: x.organization_structure_id = currv.organization_structure_id and

Line 783: per_org_structure_versions v,

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,
784: per_org_structure_versions currv
785: WHERE v.org_structure_version_id = p_org_structure_version_id AND
786: v.organization_structure_id = currv.organization_structure_id AND
787: (currv.date_to IS NULL OR

Line 784: per_org_structure_versions currv

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,
784: per_org_structure_versions currv
785: WHERE v.org_structure_version_id = p_org_structure_version_id AND
786: v.organization_structure_id = currv.organization_structure_id AND
787: (currv.date_to IS NULL OR
788: sysdate BETWEEN currv.date_from AND currv.date_to) AND