APPS.HR_NL_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 37: ,hr_all_organization_units org

33: --
34: CURSOR c_hierarchy(vp_organization_id NUMBER) IS
35: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
36: FROM hr_organization_information inf
37: ,hr_all_organization_units org
38: WHERE org.organization_id = vp_organization_id
39: AND inf.organization_id = org.business_group_id
40: AND inf.org_information_context = 'NL_BG_INFO'
41: AND inf.org_information1 IS NOT NULL;