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
1004: AND rdl.project_id = X2_project_id