APPS.PSP_PSPLDDFA_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 100: HR_ORGANIZATION_UNITS

96: DISTINCT
97: NAME
98: INTO V_INSTITUTION_NAME
99: FROM
100: HR_ORGANIZATION_UNITS
101: WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
102: RETURN V_INSTITUTION_NAME;
103: RETURN NULL;
104: EXCEPTION

Line 185: HR_ORGANIZATION_UNITS

181: DISTINCT
182: NAME
183: INTO V_ORGANIZATION_NAME
184: FROM
185: HR_ORGANIZATION_UNITS
186: WHERE ORGANIZATION_ID = CF_ORGANIZATION_NAMEFORMULA.ORGANIZATION_ID;
187: RETURN V_ORGANIZATION_NAME;
188: RETURN NULL;
189: EXCEPTION