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;