APPS.HR_ORGANIZATION_UNITS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 95: ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)

91: END chk_repbody_seat_numbers;
92: --
93: FUNCTION Is_Org_A_Node
94: (p_search_org_id IN hr_organization_units.organization_id%TYPE
95: ,p_organization_structure_id IN per_org_structure_versions_v.organization_structure_id%TYPE)
96: RETURN CHAR IS
97: --
98: Cursor c_get_structure_version Is
99: Select posvv.org_structure_version_id version_id

Line 101: per_org_structure_versions_v posvv

97: --
98: Cursor c_get_structure_version Is
99: Select posvv.org_structure_version_id version_id
100: From per_organization_structures_v posv,
101: per_org_structure_versions_v posvv
102: Where posvv.organization_structure_id = posv.organization_structure_id
103: And posv.organization_structure_id = p_organization_structure_id;
104: --
105: Cursor c_orgs_in_hierarchy

Line 106: (p_version_id IN per_org_structure_versions_v.organization_structure_id%TYPE) IS

102: Where posvv.organization_structure_id = posv.organization_structure_id
103: And posv.organization_structure_id = p_organization_structure_id;
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

Line 119: v_version_id per_org_structure_versions_v.organization_structure_id%TYPE := NULL;

115: v_org_in_hierarchy BOOLEAN := FALSE;
116: v_users_starting_node VARCHAR2(240) := NULL;
117: v_return_message VARCHAR2(5);
118: --
119: v_version_id per_org_structure_versions_v.organization_structure_id%TYPE := NULL;
120: --
121: l_proc VARCHAR2(72) := g_package||'Is_Org_A_Node';
122: --
123: BEGIN