APPS.PA_BILL_PCT dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1001: pa_expenditure_items_all ei,

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