227: if (p_project_id is not null) then
228: l_stage := 'getting the project id';
229: select SEGMENT1
230: into l_project_name
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.