DBA Data[Home] [Help]

APPS.PSP_PSPLSODR_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 103: HR_ORGANIZATION_UNITS

99: CURSOR ORG_NAME_CUR IS
100: SELECT
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