APPS.HR_DE_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 58: ,hr_all_organization_units org

54: --
55: CURSOR c_hierarchy(p_organization_id NUMBER) IS
56: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
57: FROM hr_organization_information inf
58: ,hr_all_organization_units org
59: WHERE org.organization_id = p_organization_id
60: AND inf.organization_id = org.business_group_id
61: AND inf.org_information_context = 'DE_BG_INFO'
62: AND inf.org_information1 IS NOT NULL;