APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on PA_TASKS

Line 237: L_TASK_NUMBER PA_TASKS.TASK_NUMBER%TYPE;

233: ,AWARD_ID_arg IN NUMBER
234: ,CF_PROJECT_NAME IN VARCHAR2
235: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
236: L_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE;
237: L_TASK_NUMBER PA_TASKS.TASK_NUMBER%TYPE;
238: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
239: BEGIN
240: IF EXPENDITURE_ORGANIZATION_ID IS NOT NULL THEN
241: SELECT

Line 256: PA_TASKS

252: SELECT
253: TASK_NUMBER
254: INTO L_TASK_NUMBER
255: FROM
256: PA_TASKS
257: WHERE TASK_ID = TASK_ID_arg;
258: ELSE
259: L_TASK_NUMBER := '';
260: END IF;