DBA Data[Home] [Help]

APPS.PA_BILLING_AMOUNT dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 84: FROM pa_cost_distribution_lines_all cdl

80: ) /* Exists clause added for bug 7299493 */
81:
82: UNION ALL
83: SELECT sum(nvl((cdl.burdened_cost + nvl(project_burdened_change,0)), nvl(cdl.amount,0))) BURDENED_COST
84: FROM pa_cost_distribution_lines_all cdl
85: WHERE cdl.resource_accumulated_flag = 'N'
86: AND cdl.line_type = 'R'
87: AND cdl.project_id = X2_project_id
88: AND EXISTS

Line 134: FROM pa_cost_distribution_lines_all cdl /* Added _all for bug 5953670*/

130: and pp.period_name = ta.pa_period
131: )
132: UNION ALL
133: SELECT sum(nvl((cdl.burdened_cost + nvl(project_burdened_change,0)), nvl(cdl.amount,0))) BURDENED_COST
134: FROM pa_cost_distribution_lines_all cdl /* Added _all for bug 5953670*/
135: /*pa_tasks commented for bug 6521198*/
136: WHERE EXISTS ( select 1 from pa_tasks t
137: WHERE cdl.project_id = t.project_id
138: AND cdl.task_id = t.task_id