DBA Data[Home] [Help]

APPS.PA_BILL_PCT dependencies on PA_TASKS

Line 1002: pa_tasks t

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