APPS.CSE_DEPLOYMENT_GRP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 691: FROM hr_all_organization_units ho, hr_all_organization_units hoc

687: AND ROWNUM=1;
688:
689: CURSOR c_Business_Group_cur( c_org_id NUMBER ) IS
690: SELECT ho.name
691: FROM hr_all_organization_units ho, hr_all_organization_units hoc
692: WHERE hoc.organization_id = c_org_id
693: AND ho.organization_id = hoc.business_group_id ;
694:
695: l_Business_Group_rec c_Business_Group_cur%ROWTYPE;