APPS.IGW_BUDGETS_PVT dependencies on PA_TASKS

Line 283: from pa_tasks_top_v

279: --populate the task id if project requires task
280: if l_entry_level_code in ('T','M') then
281: select task_id
282: into l_task_id
283: from pa_tasks_top_v
284: where project_id = l_project_id
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

Line 285: and wbs_sort_order = (select min(wbs_sort_order) from pa_tasks_top_v where project_id = l_project_id);

281: select task_id
282: into l_task_id
283: from pa_tasks_top_v
284: where project_id = l_project_id
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

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;

Line 317: from pa_tasks

313: --bug 3527151 no data found raising exception
314: begin
315: select task_id
316: into l_task_id
317: from pa_tasks
318: where project_id = l_project_id
319: and (PA_TASK_UTILS.CHECK_CHILD_EXISTS(TASK_ID) = 0 or TOP_TASK_ID = task_id)
320: and top_task_id = l_task_id
321: and rownum < 2;