APPS.IGW_BUDGETS_PVT dependencies on PA_TASKS_LOWEST_V

Line 289: from pa_tasks_lowest_v

285: and wbs_sort_order = (select min(wbs_sort_order) from pa_tasks_top_v where project_id = l_project_id);
286: elsif l_entry_level_code = 'L' then
287: select task_id
288: into l_task_id
289: from pa_tasks_lowest_v
290: where project_id = l_project_id
291: and wbs_sort_order = (select min(wbs_sort_order) from pa_tasks_lowest_v where project_id = l_project_id);
292: end if;
293: */

Line 291: and wbs_sort_order = (select min(wbs_sort_order) from pa_tasks_lowest_v where project_id = l_project_id);

287: select task_id
288: into l_task_id
289: from pa_tasks_lowest_v
290: where project_id = l_project_id
291: and wbs_sort_order = (select min(wbs_sort_order) from pa_tasks_lowest_v where project_id = l_project_id);
292: end if;
293: */
294: if l_entry_level_code = 'T' then
295: -- l_task_id is already known since funding is always at top task level

Line 302: from pa_tasks_lowest_v

298: --bug 3527151 no data found raising exception
299: begin
300: select task_id
301: into l_task_id
302: from pa_tasks_lowest_v
303: where project_id = l_project_id
304: and top_task_id = l_task_id
305: and wbs_sort_order = (select min(wbs_sort_order)
306: from pa_tasks_lowest_v

Line 306: from pa_tasks_lowest_v

302: from pa_tasks_lowest_v
303: where project_id = l_project_id
304: and top_task_id = l_task_id
305: and wbs_sort_order = (select min(wbs_sort_order)
306: from pa_tasks_lowest_v
307: where project_id = l_project_id
308: and top_task_id = l_task_id);
309: exception
310: when no_data_found then null;