DBA Data[Home] [Help]

APPS.HR_SA_ORG_INFO dependencies on DUAL

Line 11: FROM dual

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

Line 26: FROM dual

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