DBA Data[Home] [Help]

APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on PA_PROJECTS_ALL

Line 233: L_PROJECT_NUMBER PA_PROJECTS_ALL.SEGMENT1%TYPE;

229: ,TASK_ID IN NUMBER
230: ,PROJECT_ID IN NUMBER
231: ,AWARD_ID IN VARCHAR2
232: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
233: L_PROJECT_NUMBER PA_PROJECTS_ALL.SEGMENT1%TYPE;
234: L_TASK_NUMBER PA_TASKS.TASK_NUMBER%TYPE;
235: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
236: V_AWARD_NAME VARCHAR2(50);
237: BEGIN

Line 270: PA_PROJECTS_ALL

266: SELECT
267: SEGMENT1
268: INTO L_PROJECT_NUMBER
269: FROM
270: PA_PROJECTS_ALL
271: WHERE PROJECT_ID = cf_charging_instructionsformul.PROJECT_ID;
272: ELSE
273: L_PROJECT_NUMBER := '';
274: END IF;