DBA Data[Home] [Help]

APPS.PSP_PSPRCLSL_XMLP_PKG dependencies on FND_PROFILE

Line 173: fnd_profile.get('PSP_ORG_REPORT', x_org_id);

169:
170: function CF_orgFormula return VARCHAR2 is
171: x_org_name hr_all_organization_units_tl.name%TYPE; x_org_id varchar2(15);
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);