APPS.PA_BILLING_PUB dependencies on PA_TASKS

Line 354: FROM pa_tasks t,

350: decode( X_which_amount, 'I', nvl(rdl.bill_amount,0),
351: 'R', nvl(rdl.amount,0),
352: 'C', nvl(ei.raw_cost,0),
353: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
354: FROM pa_tasks t,
355: pa_expenditure_items_all ei,
356: pa_expenditure_items_all ei2,
357: pa_cust_rev_dist_lines rdl
358: WHERE

Line 410: FROM pa_tasks t,

406: decode( X_which_amount, 'I', nvl(rdl.bill_amount,0),
407: 'R', nvl(rdl.amount,0),
408: 'C', nvl(ei.raw_cost,0),
409: 'B', nvl(ei.burden_cost,0), nvl(ei.raw_cost,0)) amt
410: FROM pa_tasks t,
411: pa_expenditure_items_all ei2,
412: pa_expenditure_items_all ei,
413: pa_cust_rev_dist_lines rdl2,
414: pa_cust_rev_dist_lines rdl,

Line 468: pa_tasks t

464: nvl(ei.burden_cost,0)) amt,
465: decode(ei.adjusted_expenditure_item_id, NULL, 'N','Y') ei_adj
466: FROM pa_expenditure_items_all ei,
467: /* pa_expenditure_items_all ei2, commented for Bug#2499051*/
468: pa_tasks t
469: WHERE
470: ei.task_id = t.task_Id
471: AND (t.top_task_id = X_top_task_id
472: OR X_top_task_id IS NULL)