DBA Data[Home] [Help]

APPS.PSP_PSPLSODR_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 105: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

101: NAME
102: FROM
103: HR_ORGANIZATION_UNITS
104: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
105: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
106: BEGIN
107: IF EXPENDITURE_ORGANIZATION_ID IS NOT NULL THEN
108: OPEN ORG_NAME_CUR;
109: FETCH ORG_NAME_CUR