APPS.IGC_CC_APPROVAL_PROCESS dependencies on HR_ORGANIZATION_UNITS

Line 171: FROM hr_organization_units

167: AND lookup_type = 'IGC_CC_TYPE';
168:
169: CURSOR c_org_name IS
170: SELECT name
171: FROM hr_organization_units
172: WHERE organization_id = p_org_id;
173:
174: l_value VARCHAR2(255);
175: l_full_path VARCHAR2(255);