APPS.PA_MC_BILLING_PVT dependencies on PA_TASKS

Line 323: FROM pa_tasks

319: FROM dual
320: WHERE p_task_id is null
321: UNION
322: SELECT 'T'
323: FROM pa_tasks
324: WHERE p_task_id is not null
325: AND task_id = p_task_id
326: AND parent_task_id is null
327: UNION

Line 329: FROM pa_tasks

325: AND task_id = p_task_id
326: AND parent_task_id is null
327: UNION
328: SELECT 'M'
329: FROM pa_tasks
330: WHERE p_task_id is not null
331: AND task_id = p_task_id
332: AND parent_task_id is not null
333: AND exists (select 'X'

Line 334: from pa_tasks

330: WHERE p_task_id is not null
331: AND task_id = p_task_id
332: AND parent_task_id is not null
333: AND exists (select 'X'
334: from pa_tasks
335: where parent_task_id = p_task_id)
336: UNION
337: SELECt 'L'
338: FROM dual

Line 341: from pa_tasks

337: SELECt 'L'
338: FROM dual
339: WHERE p_task_id is not null
340: AND not exists (select 'X'
341: from pa_tasks
342: where parent_task_id = p_task_id);
343:
344:
345:

Line 417: FROM pa_tasks t, pa_mc_budget_lines mcbl , pa_budget_lines bl,

413: SUM(NVL(mcbl.revenue,0))
414: INTO l_raw_cost_total,
415: l_burdened_cost_total,
416: l_revenue_total
417: FROM pa_tasks t, pa_mc_budget_lines mcbl , pa_budget_lines bl,
418: pa_resource_assignments a
419: WHERE bl.budget_line_id = mcbl.budget_line_id
420: AND a.budget_version_id = p_budget_version_id
421: AND a.task_id = t.task_id

Line 442: FROM pa_tasks

438: pa_resource_assignments a
439: WHERE bl.budget_line_id = mcbl.budget_line_id
440: AND a.budget_version_id = p_budget_version_id
441: AND a.task_id in (SELECT task_id
442: FROM pa_tasks
443: START with task_id = p_task_id
444: CONNECT by prior task_id = parent_task_id)
445: AND a.resource_assignment_id = bl.resource_assignment_id
446: AND mcbl.set_of_books_id = p_rsob_id

Line 540: pa_tasks t, pa_periods pp

536: SELECT SUM(NVL(mccdl.burdened_cost, NVL(mccdl.amount,0)))
537: INTO l_cost_amount
538: FROM pa_cost_distribution_lines_all cdl,
539: pa_mc_cost_dist_lines_all mccdl,
540: pa_tasks t, pa_periods pp
541: WHERE cdl.project_id = t.project_id
542: AND t.project_id = p_project_id
543: AND nvl(cdl.task_id, -1) = nvl(t.task_id, -1)
544: AND nvl(t.task_id, -1) = nvl(p_task_id, nvl(t.task_id, -1))