7: --
8: CURSOR organization_hierarchy(p_org_id NUMBER, p_org_structure_version_id NUMBER, p_org_exists_in_hierarchy VARCHAR2) IS
9: SELECT p_org_id organization_id_parent
10: ,0 lev
11: FROM dual
12: WHERE p_org_exists_in_hierarchy = 'Y'
13: UNION
14: SELECT organization_id_parent
15: ,level lev
22: --
23: CURSOR org_hierarchy(p_org_id NUMBER, p_org_structure_version_id NUMBER, p_org_exists_in_hierarchy VARCHAR2) IS
24: SELECT p_org_id organization_id_parent
25: ,0 lev
26: FROM dual
27: WHERE p_org_exists_in_hierarchy = 'Y'
28: UNION
29: SELECT organization_id_parent
30: ,level lev