231: from PA_PROJECTS_ALL
232: where project_id = p_project_id;
233:
234: -- Bug 16841557, replaced the call of pa_tasks with
235: --pa_tasks_expend_v as part of CBS project.
236: if (p_task_id is not null) then
237: l_stage := 'getting the task id';
238: select TASK_NUMBER
239: into l_task_number
236: if (p_task_id is not null) then
237: l_stage := 'getting the task id';
238: select TASK_NUMBER
239: into l_task_number
240: from pa_tasks_expend_v
241: where project_id = p_project_id and task_id = p_task_id;
242: end if;
243:
244: end if;