APPS.PSP_PSPLSEMP_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 10: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

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;
13: FETCH ORG_NAME_CUR
14: INTO L_ORG_NAME;

Line 156: L_EXP_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

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
159: OPEN EXP_ORG_NAME_CUR;
160: FETCH EXP_ORG_NAME_CUR