APPS.HR_ORGANIZATION_UNITS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS_V

Line 108: from per_org_structure_elements_v posev

104: --
105: Cursor c_orgs_in_hierarchy
106: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS
107: select posev.organization_id_parent org_id
108: from per_org_structure_elements_v posev
109: where posev.org_Structure_version_id = p_version_id
110: UNION
111: select posev.organization_id_child org_id
112: from per_org_structure_elements_v posev

Line 112: from per_org_structure_elements_v posev

108: from per_org_structure_elements_v posev
109: where posev.org_Structure_version_id = p_version_id
110: UNION
111: select posev.organization_id_child org_id
112: from per_org_structure_elements_v posev
113: where posev.org_Structure_version_id = p_version_id;
114: --
115: v_org_in_hierarchy BOOLEAN := FALSE;
116: v_users_starting_node VARCHAR2(240) := NULL;