APPS.PA_BILLING_AMOUNT dependencies on PA_TXN_ACCUM

Line 65: pa_txn_accum ta

61: from (
62: SELECT sum(nvl(ta.tot_burdened_cost, nvl(ta.tot_raw_cost,0)) +
63: nvl(ta.i_tot_burdened_cost, nvl(i_tot_raw_cost,0))) BURDENED_COST
64: FROM
65: pa_txn_accum ta
66: WHERE ta.project_id = X2_project_id
67: AND EXISTS
68: (
69: select 1

Line 113: pa_txn_accum ta,

109:
110: SELECT sum(nvl(ta.tot_burdened_cost, nvl(ta.tot_raw_cost,0)) +
111: nvl(ta.i_tot_burdened_cost, nvl(i_tot_raw_cost,0))) BURDENED_COST
112: FROM
113: pa_txn_accum ta,
114: pa_tasks t
115: WHERE ta.task_id = t.task_id
116: AND t.top_task_id = X2_task_id
117: AND t.project_id = X2_project_id