APPS.PA_BASELINE_FUNDING_PKG dependencies on PA_PROJECTS_ALL

Line 438: FROM pa_projects_all

434:
435:
436: CURSOR proj_dates IS
437: SELECT start_date, completion_date
438: FROM pa_projects_all
439: WHERE project_id = p_project_id;
440: /* Added for fp */
441: CURSOR funding_amount (x_funding_level varchar) is
442: SELECT task_id, sum(nvl(projfunc_allocated_amount,0)) pf_fund_amt,

Line 533: FROM pa_projects_all

529: as done in the bug 3739353 starts here */
530: BEGIN
531: SELECT project_id
532: INTO l_project_id
533: FROM pa_projects_all
534: WHERE project_id = p_project_id
535: FOR UPDATE NOWAIT;
536:
537: EXCEPTION