DBA Data[Home] [Help]

APPS.PSP_PSPLDAWD_XMLP_PKG dependencies on PA_TASKS

Line 234: L_TASK_NUMBER PA_TASKS.TASK_NUMBER%TYPE;

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
238: SELECT

Line 260: PA_TASKS

256: SELECT
257: TASK_NUMBER
258: INTO L_TASK_NUMBER
259: FROM
260: PA_TASKS
261: WHERE TASK_ID = cf_charging_instructionsformul.TASK_ID;
262: ELSE
263: L_TASK_NUMBER := '';
264: END IF;