APPS.PQH_ASG_WRAPPER dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 558: -- per_org_structure_elements is used instead of per_org_structure_elements_v.

554: And fs.session_id = userenv('sessionid');
555: --
556: -- Bug fix 3648688.
557: -- Cursor modified to improve performance.
558: -- per_org_structure_elements is used instead of per_org_structure_elements_v.
559:
560: Cursor c_orgs_in_hierarchy
561: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS
562: select posev.organization_id_parent org_id

Line 563: from per_org_structure_elements posev

559:
560: Cursor c_orgs_in_hierarchy
561: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS
562: select posev.organization_id_parent org_id
563: from per_org_structure_elements posev
564: where posev.org_Structure_version_id = p_version_id
565: UNION
566: select posev.organization_id_child org_id
567: from per_org_structure_elements posev

Line 567: from per_org_structure_elements posev

563: from per_org_structure_elements posev
564: where posev.org_Structure_version_id = p_version_id
565: UNION
566: select posev.organization_id_child org_id
567: from per_org_structure_elements posev
568: where posev.org_Structure_version_id = p_version_id;
569: --
570: v_org_in_hierarchy BOOLEAN := FALSE;
571: v_users_starting_node VARCHAR2(240) := NULL;

Line 640: from per_org_structure_elements ose,

636: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
637: --
638: Cursor c_get_hierarchy_root(p_org_hierarchy_id number) is
639: select organization_id_parent
640: from per_org_structure_elements ose,
641: per_org_structure_versions osv
642: where osv.organization_structure_id = p_org_hierarchy_id
643: and hr_general.effective_date between osv.date_from
644: and nvl(osv.date_to,hr_general.end_of_time)

Line 648: from per_org_structure_elements ose2

644: and nvl(osv.date_to,hr_general.end_of_time)
645: and osv.org_structure_version_id = ose.org_structure_version_id
646: and not exists
647: (select 'X'
648: from per_org_structure_elements ose2
649: where ose.organization_id_parent = ose2.organization_id_child
650: and osv.org_structure_version_id=ose2.org_structure_version_id);
651: --
652: v_org_in_hierarchy BOOLEAN := FALSE;

Line 740: FROM per_org_structure_elements o

736: into l_dummy
737: from dual
738: where g_org_hierarchy_root in (
739: SELECT o.organization_id_parent
740: FROM per_org_structure_elements o
741: CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent
742: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
743: START WITH o.organization_id_child = p_search_org_id
744: AND o.org_structure_version_id =

Line 800: FROM per_org_structure_elements o

796: into l_dummy
797: from dual
798: where g_org_starting_node in (
799: SELECT o.organization_id_parent
800: FROM per_org_structure_elements o
801: CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent
802: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
803: START WITH o.organization_id_child = p_search_org_id
804: AND o.org_structure_version_id =