APPS.PSP_PSPLSEMP_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 8: HR_ORGANIZATION_UNITS

4: CURSOR ORG_NAME_CUR IS
5: SELECT
6: NAME
7: FROM
8: HR_ORGANIZATION_UNITS
9: WHERE ORGANIZATION_ID = ORGANIZATION_ID_V;
10: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
11: BEGIN
12: OPEN ORG_NAME_CUR;

Line 154: HR_ORGANIZATION_UNITS

150: CURSOR EXP_ORG_NAME_CUR IS
151: SELECT
152: NAME
153: FROM
154: HR_ORGANIZATION_UNITS
155: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
156: L_EXP_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
157: BEGIN
158: IF (EXPENDITURE_ORGANIZATION_ID IS NOT NULL) THEN