APPS.OTA_LEARNER_ACCESS_UTIL dependencies on OTA_USER_GROUP_ELEMENTS

Line 563: FROM ota_user_group_elements a, ota_user_groups_b b

559: FROM ( SELECT a.user_group_id user_group_id,
560: a.child_user_group_id child_user_group_id,
561: level UG_Level,
562: b.user_group_operator user_group_operator
563: FROM ota_user_group_elements a, ota_user_groups_b b
564: WHERE a.user_group_id = b.user_group_id
565: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and trunc(nvl(b.end_date_active, sysdate+1))
566: and (b.business_group_id = p_business_group_id or p_business_group_id = -1)
567: START WITH a.user_group_id = p_user_group_id

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

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

Line 573: p_org_structure_version_id ota_user_group_elements.org_structure_version_id%type) is

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

Line 600: from ota_user_group_elements uge, ota_user_groups_b ugb

596: uge.person_id,
597: uge.match_type,
598: uge.child_user_group_id,
599: ugb.user_group_operator
600: from ota_user_group_elements uge, ota_user_groups_b ugb
601: where uge.user_group_id = p_user_group_id
602: and uge.user_group_id = ugb.user_group_id
603: and trunc(sysdate) between trunc(nvl(ugb.start_date_active, sysdate)) and trunc(nvl(ugb.end_date_active, sysdate+1)) --Bug#7120108
604: and (uge.business_group_id = p_business_group_id or p_business_group_id = -1);

Line 2450: FROM OTA_USER_GROUP_ELEMENTS

2446:
2447: BEGIN
2448:
2449: SELECT count(user_group_element_id) into total_elements_count
2450: FROM OTA_USER_GROUP_ELEMENTS
2451: WHERE user_group_id in ( SELECT child_user_group_id
2452: FROM ( SELECT a.child_user_group_id
2453: FROM ota_user_group_elements a,
2454: ota_user_groups_b b

Line 2453: FROM ota_user_group_elements a,

2449: SELECT count(user_group_element_id) into total_elements_count
2450: FROM OTA_USER_GROUP_ELEMENTS
2451: WHERE user_group_id in ( SELECT child_user_group_id
2452: FROM ( SELECT a.child_user_group_id
2453: FROM ota_user_group_elements a,
2454: ota_user_groups_b b
2455: WHERE a.user_group_id = b.user_group_id
2456: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2457: trunc(nvl(b.end_date_active, sysdate+1))

Line 2466: FROM OTA_USER_GROUP_ELEMENTS a,

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,
2467: PER_PEOPLE_F e,
2468: PER_JOBS_VL job,
2469: HR_ORGANIZATION_UNITS org,
2470: PER_POSITIONS pos

Line 2473: FROM ota_user_group_elements a,

2469: HR_ORGANIZATION_UNITS org,
2470: PER_POSITIONS pos
2471: WHERE a.user_group_id in ( SELECT child_user_group_id
2472: FROM ( SELECT a.child_user_group_id
2473: FROM ota_user_group_elements a,
2474: ota_user_groups_b b
2475: WHERE a.user_group_id = b.user_group_id
2476: and trunc(sysdate) between trunc(nvl(b.start_date_active, sysdate)) and
2477: trunc(nvl(b.end_date_active, sysdate+1))