APPS.PSP_PSPLDPRJ_XMLP_PKG dependencies on GMS_AWARDS_ALL

Line 236: L_AWARD_NUMBER GMS_AWARDS_ALL.AWARD_NUMBER%TYPE;

232: ,TASK_ID_arg IN NUMBER
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 VARCHAR(300); -- PA_TASKS.TASK_NUMBER%TYPE -- Bug 16391366 (27/03/2013)
238: L_EXP_ORG HR_ORGANIZATION_UNITS.NAME%TYPE;
239: BEGIN
240: IF EXPENDITURE_ORGANIZATION_ID IS NOT NULL THEN

Line 266: GMS_AWARDS_ALL

262: SELECT
263: AWARD_NUMBER
264: INTO L_AWARD_NUMBER
265: FROM
266: GMS_AWARDS_ALL
267: WHERE AWARD_ID = AWARD_ID_arg;
268: ELSE
269: L_AWARD_NUMBER := '';
270: END IF;