APPS.PQH_ASG_WRAPPER dependencies on PER_POS_STRUCTURE_VERSIONS_V

Line 850: ,p_position_structure_id IN per_pos_structure_versions_v.position_structure_id%TYPE

846: -- ---------------------------------------------------------------------------+
847: --
848: FUNCTION Is_Pos_A_Node
849: (p_search_pos_id IN per_positions.position_id%TYPE
850: ,p_position_structure_id IN per_pos_structure_versions_v.position_structure_id%TYPE
851: ,p_effective_date IN DATE)
852: RETURN CHAR IS
853: --
854: Cursor c_get_structure_version Is

Line 857: per_pos_structure_versions_v ppsvv

853: --
854: Cursor c_get_structure_version Is
855: Select ppsvv.pos_structure_version_id version_id
856: From per_position_structures_v ppsv,
857: per_pos_structure_versions_v ppsvv
858: Where ppsvv.position_structure_id = ppsv.position_structure_id
859: And ppsv.position_structure_id = p_position_structure_id
860: and p_effective_date between to_date(date_from,'DD/MM/YYYY') and
861: NVL(to_date(date_to,'DD/MM/YYYY'),p_effective_date);

Line 868: (p_version_id IN per_pos_structure_versions_v.position_structure_id%TYPE) IS

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
870: from per_pos_structure_elements ppsev
871: where ppsev.pos_structure_version_id = p_version_id
872: UNION

Line 881: v_version_id per_pos_structure_versions_v.position_structure_id%TYPE := NULL;

877: v_pos_in_hierarchy BOOLEAN := FALSE;
878: v_users_starting_node VARCHAR2(240) := NULL;
879: v_return_message VARCHAR2(5);
880: --
881: v_version_id per_pos_structure_versions_v.position_structure_id%TYPE := NULL;
882: --
883: l_proc varchar2(72) := g_package||'Is_Pos_A_Node';
884: --
885: BEGIN

Line 1045: FROM per_pos_structure_versions v

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 =
1044: (SELECT v.pos_structure_version_id
1045: FROM per_pos_structure_versions v
1046: WHERE v.position_structure_id = g_pos_hierarchy_id
1047: AND hr_general.effective_date BETWEEN v.date_from
1048: AND NVL(v.date_to, hr_general.end_of_time)));
1049: if l_dummy = 'X' then

Line 1104: FROM per_pos_structure_versions v

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 =
1103: (SELECT v.pos_structure_version_id
1104: FROM per_pos_structure_versions v
1105: WHERE v.position_structure_id = g_pos_hierarchy_id
1106: AND hr_general.effective_date BETWEEN v.date_from
1107: AND NVL(v.date_to, hr_general.end_of_time)));
1108: if l_dummy = 'X' then