APPS.PSP_PSPRCLSL_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 176: select name into x_org_name from hr_organization_units where organization_id = TO_NUMBER(x_org_id);

172: begin
173: fnd_profile.get('PSP_ORG_REPORT', x_org_id);
174:
175: if x_org_id is not null then
176: select name into x_org_name from hr_organization_units where organization_id = TO_NUMBER(x_org_id);
177: return(x_org_name);
178: end if;
179:
180: RETURN NULL;