[Home] [Help]
147: --
148: CURSOR c_get_parent_id(c_org_id IN NUMBER
149: ,c_version_id IN NUMBER) IS
150: SELECT organization_id_parent
151: FROM per_org_structure_elements
152: WHERE organization_id_child = c_org_id
153: AND org_structure_version_id = c_version_id
154: AND business_group_id = p_business_group_id;
155:
891: --
892: CURSOR c_get_parent_id(c_org_id IN NUMBER
893: ,c_version_id IN NUMBER) IS
894: SELECT organization_id_parent
895: FROM per_org_structure_elements
896: WHERE organization_id_child = c_org_id
897: AND org_structure_version_id = c_version_id
898: AND business_group_id = p_business_group_id;
899: