423:
424:
425: CURSOR proj_dates IS
426: SELECT start_date, completion_date
427: FROM pa_projects_all
428: WHERE project_id = p_project_id;
429: /* Added for fp */
430: CURSOR funding_amount is
431: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,
510: as done in the bug 3739353 starts here */
511: BEGIN
512: SELECT project_id
513: INTO l_project_id
514: FROM pa_projects_all
515: WHERE project_id = p_project_id
516: FOR UPDATE NOWAIT;
517:
518: EXCEPTION