[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(
decode(x_amt_type,'RC',nvl(raw_cost,0),'BC',nvl(burdened_cost,0),'RE',nvl(revenue,0),
'QU',decode(track_as_labor_flag,'Y',nvl(quantity,0),0))),
sum(
decode(x_amt_type,'RC',nvl(raw_cost,0),'BC',nvl(burdened_cost,0),'RE',nvl(revenue,0),
'QU',nvl(quantity,0),0))
into x_tot,
x_tot2
from pa_budget_lines_v
where budget_version_id = x_budget_version_id
and task_id = x_task_id
and resource_list_member_id = x_RLMI
and project_id = x_project_id
and start_date between x_totals_start_date
and x_totals_end_date ;
select sum(decode(period_name,x_p1,
decode(x_list_view_totals, 'RC', nvl(raw_cost,0),
'BC', nvl(burdened_cost,0),
'RE', nvl(revenue,0),
'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
0), 0) ) ,
sum(decode(period_name,x_p2,
decode(x_list_view_totals, 'RC', nvl(raw_cost,0),
'BC', nvl(burdened_cost,0),
'RE', nvl(revenue,0),
'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
0), 0) ) ,
sum(decode(period_name,x_p3,
decode(x_list_view_totals, 'RC', nvl(raw_cost,0),
'BC', nvl(burdened_cost,0),
'RE', nvl(revenue,0),
'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
0), 0) ) ,
sum(decode(period_name,x_p4,
decode(x_list_view_totals, 'RC', nvl(raw_cost,0),
'BC', nvl(burdened_cost,0),
'RE', nvl(revenue,0),
'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
0), 0) )
into x_p1_tot,
x_p2_tot,
x_p3_tot,
x_p4_tot
from pa_budget_lines_v
where budget_version_id = x_budget_version_id
and task_id = x_task_id
and project_id = x_project_id
and start_date between x_start_date
and x_end_date ;
select sum(decode(x_list_view_totals, 'RC', nvl(raw_cost,0),
'BC', nvl(burdened_cost,0),
'RE', nvl(revenue,0),
'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
0) )
into x_grand_tot
from pa_budget_lines_v
where budget_version_id = x_budget_version_id
and task_id = x_task_id
and project_id = x_project_id
and start_date between x_start_date
and x_end_date ;