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 OTA_USER_GROUP_ELEMENTS

Line 539: FROM ota_user_group_elements a, ota_user_groups_b b

535: FROM ( SELECT a.user_group_id user_group_id,
536: a.child_user_group_id child_user_group_id,
537: level UG_Level,
538: b.user_group_operator user_group_operator
539: FROM ota_user_group_elements a, ota_user_groups_b b
540: WHERE a.user_group_id = b.user_group_id
541: and (p_ignore_ug_date_check = 'Y' or
542: trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and trunc(nvl(b.end_date_active, sysdate+1)))
543: and (b.business_group_id = p_business_group_id or p_business_group_id = -1)

Line 549: cursor csr_org_hierarchy(p_organization_id ota_user_group_elements.organization_id%type,

545: CONNECT BY PRIOR a.child_user_group_id = a.user_group_id
546: ORDER by LEVEL desc
547: ) WHERE child_user_group_id is not null;
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

Line 550: p_org_structure_version_id ota_user_group_elements.org_structure_version_id%type) is

546: ORDER by LEVEL desc
547: ) WHERE child_user_group_id is not null;
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

Line 580: from ota_user_group_elements uge, ota_user_groups_b ugb

576: uge.child_user_group_id,
577: ugb.user_group_operator,
578: uge.elig_prfl_id,
579: uge.user_group_id
580: from ota_user_group_elements uge, ota_user_groups_b ugb
581: where uge.user_group_id = p_user_group_id
582: and uge.user_group_id = ugb.user_group_id
583: and (p_ignore_ug_date_check = 'Y' or
584: trunc(sysdate) between trunc(nvl(ugb.start_date_active, sysdate)) and trunc(nvl(ugb.end_date_active, sysdate+1))) --Bug#7120108

Line 2511: whereclause := whereclause || ' person_id in (select person_id from ota_user_group_elements where ';

2507: end loop;
2508: elsif elements.elig_prfl_id is not null then --Eligibility profile
2509: l_status := ota_elig_profile_util.check_processing_status(p_user_group_id);
2510: if l_status = 'A' then --user group is not under processing of a conc program
2511: whereclause := whereclause || ' person_id in (select person_id from ota_user_group_elements where ';
2512: whereclause := whereclause || 'user_group_id = '||TO_CHAR(elements.user_group_id);
2513: whereclause := whereclause || ' and elig_prfl_id is not null';
2514: whereclause := whereclause || ' and person_id is not null and nvl( processing_status,''A'') = ''A'' )';
2515:

Line 2584: FROM OTA_USER_GROUP_ELEMENTS

2580:
2581: BEGIN
2582:
2583: SELECT count(user_group_element_id) into total_elements_count
2584: FROM OTA_USER_GROUP_ELEMENTS
2585: WHERE user_group_id in ( SELECT child_user_group_id
2586: FROM ( SELECT a.child_user_group_id
2587: FROM ota_user_group_elements a,
2588: ota_user_groups_b b

Line 2587: FROM ota_user_group_elements a,

2583: SELECT count(user_group_element_id) into total_elements_count
2584: FROM OTA_USER_GROUP_ELEMENTS
2585: WHERE user_group_id in ( SELECT child_user_group_id
2586: FROM ( SELECT a.child_user_group_id
2587: FROM ota_user_group_elements a,
2588: ota_user_groups_b b
2589: WHERE a.user_group_id = b.user_group_id
2590: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2591: trunc(nvl(b.end_date_active, sysdate+1))

Line 2601: FROM OTA_USER_GROUP_ELEMENTS a,

2597: or business_group_id = p_business_group_id)
2598: and( person_id is null or elig_prfl_id is null);
2599:
2600: SELECT count(a.user_group_element_id) into restricted_elements_count
2601: FROM OTA_USER_GROUP_ELEMENTS a,
2602: PER_PEOPLE_F e,
2603: PER_JOBS_VL job,
2604: HR_ORGANIZATION_UNITS org,
2605: PER_POSITIONS pos,

Line 2609: FROM ota_user_group_elements a,

2605: PER_POSITIONS pos,
2606: BEN_ELIGY_PRFL_F elig_profile
2607: WHERE a.user_group_id in ( SELECT child_user_group_id
2608: FROM ( SELECT a.child_user_group_id
2609: FROM ota_user_group_elements a,
2610: ota_user_groups_b b
2611: WHERE a.user_group_id = b.user_group_id
2612: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2613: trunc(nvl(b.end_date_active, sysdate+1))