APPS.PA_BILL_PCT dependencies on PA_EXPENDITURE_ITEMS_ALL
Line 999: pa_expenditure_items_all ei,
995: /* Change this column from amount to projfunc_bill_amount for MCB2 */
996: SELECT sum(nvl(rdl.projfunc_bill_amount,0))
997: INTO task_billed_ccinv
998: FROM pa_cust_rev_dist_lines rdl, 999: pa_expenditure_items_all ei, 1000: pa_tasks t
1001: WHERE ei.task_id = t.task_id
1002: AND ei.Project_ID = t.Project_ID -- Perf Bug 2695332
1003: AND ei.expenditure_item_id = rdl.expenditure_item_id