APPS.HR_SA_ORG_INFO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 50: ,hr_all_organization_units org

46: --
47: CURSOR c_hierarchy(p_organization_id NUMBER) IS
48: SELECT TO_NUMBER(inf.org_information1) organization_structure_id
49: FROM hr_organization_information inf
50: ,hr_all_organization_units org
51: WHERE org.organization_id = p_organization_id
52: AND inf.organization_id = org.business_group_id
53: AND inf.org_information_context = 'SA_HR_BG_INFO'
54: AND inf.org_information1 IS NOT NULL;