APPS.PQH_ASG_WRAPPER dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 865: -- per_pos_structure_elements is used instead of per_pos_structure_elements_v.

861: NVL(to_date(date_to,'DD/MM/YYYY'),p_effective_date);
862: --
863: -- Bug fix 3648688.
864: -- cursor modified to improve performance.
865: -- per_pos_structure_elements is used instead of per_pos_structure_elements_v.
866:
867: Cursor c_pos_in_hierarchy
868: (p_version_id IN per_pos_structure_versions_v.position_structure_id%TYPE) IS
869: select ppsev.parent_position_id pos_id

Line 870: from per_pos_structure_elements ppsev

866:
867: Cursor c_pos_in_hierarchy
868: (p_version_id IN per_pos_structure_versions_v.position_structure_id%TYPE) IS
869: select ppsev.parent_position_id pos_id
870: from per_pos_structure_elements ppsev
871: where ppsev.pos_structure_version_id = p_version_id
872: UNION
873: select ppsev.subordinate_position_id pos_id
874: from per_pos_structure_elements ppsev

Line 874: from per_pos_structure_elements ppsev

870: from per_pos_structure_elements ppsev
871: where ppsev.pos_structure_version_id = p_version_id
872: UNION
873: select ppsev.subordinate_position_id pos_id
874: from per_pos_structure_elements ppsev
875: where ppsev.pos_structure_version_id = p_version_id;
876: --
877: v_pos_in_hierarchy BOOLEAN := FALSE;
878: v_users_starting_node VARCHAR2(240) := NULL;

Line 935: from per_pos_structure_elements ose,

931: RETURN CHAR IS
932: --
933: Cursor c_get_hierarchy_root(p_pos_hierarchy_id number) is
934: select parent_position_id
935: from per_pos_structure_elements ose,
936: per_pos_structure_versions osv
937: where osv.position_structure_id = p_pos_hierarchy_id
938: and hr_general.effective_date between osv.date_from
939: and nvl(osv.date_to,hr_general.end_of_time)

Line 943: from per_pos_structure_elements ose2

939: and nvl(osv.date_to,hr_general.end_of_time)
940: and osv.pos_structure_version_id = ose.pos_structure_version_id
941: and not exists
942: (select 'X'
943: from per_pos_structure_elements ose2
944: where ose.parent_position_id= ose2.subordinate_position_id
945: and osv.pos_structure_version_id=ose2.pos_structure_version_id);
946: --
947: Cursor c_is_field_populated Is

Line 1039: FROM per_pos_structure_elements o

1035: into l_dummy
1036: from dual
1037: where g_pos_hierarchy_root in (
1038: SELECT o.parent_position_id
1039: FROM per_pos_structure_elements o
1040: CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id
1041: AND o.pos_structure_version_id = PRIOR o.pos_structure_version_id
1042: START WITH o.subordinate_position_id = p_search_pos_id
1043: AND o.pos_structure_version_id =

Line 1098: FROM per_pos_structure_elements o

1094: into l_dummy
1095: from dual
1096: where g_pos_starting_node in (
1097: SELECT o.parent_position_id
1098: FROM per_pos_structure_elements o
1099: CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id
1100: AND o.pos_structure_version_id = PRIOR o.pos_structure_version_id
1101: START WITH o.subordinate_position_id = p_search_pos_id
1102: AND o.pos_structure_version_id =