APPS.PSP_PSPRCPGD_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

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

269: x_org_name hr_all_organization_units_tl.name%TYPE; x_org_id varchar2(15);
270: begin
271: fnd_profile.get('PSP_ORG_REPORT', x_org_id);
272: if x_org_id is not null then
273: select name into x_org_name from hr_organization_units where organization_id = TO_NUMBER(x_org_id);
274: return(x_org_name);
275: end if;
276:
277: RETURN NULL;