[Home] [Help]
293: SELECT
294: PROJECT_NUMBER
295: INTO L_PROJECT_NUMBER
296: FROM
297: PA_PROJECTS_EXPEND_V PPEV
298: WHERE PROJECT_ID = PPEV.PROJECT_ID
299: AND ROWNUM = 1;
300: EXCEPTION
301: WHEN OTHERS THEN