APPS.PSP_PSPLSODL_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 11: HR_ORGANIZATION_UNITS

7: DISTINCT
8: NAME
9: INTO V_ORGANIZATION_NAME
10: FROM
11: HR_ORGANIZATION_UNITS
12: WHERE ORGANIZATION_ID = ORGANIZATION_ID_v;
13: RETURN V_ORGANIZATION_NAME;
14: RETURN NULL;
15: EXCEPTION

Line 301: HR_ORGANIZATION_UNITS

297: DISTINCT
298: NAME
299: INTO V_INSTITUTION_NAME
300: FROM
301: HR_ORGANIZATION_UNITS
302: WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
303: RETURN V_INSTITUTION_NAME;
304: RETURN NULL;
305: EXCEPTION