DBA Data[Home] [Help]

APPS.PA_BUDGET_MATRIX dependencies on PA_BUDGET_LINES_V

Line 169: from pa_budget_lines_v

165: decode(x_amt_type,'RC',nvl(raw_cost,0),'BC',nvl(burdened_cost,0),'RE',nvl(revenue,0),
166: 'QU',nvl(quantity,0),0))
167: into x_tot,
168: x_tot2
169: from pa_budget_lines_v
170: where budget_version_id = x_budget_version_id
171: and task_id = x_task_id
172: and resource_list_member_id = x_RLMI
173: and project_id = x_project_id

Line 252: from pa_budget_lines_v

248: into x_p1_tot,
249: x_p2_tot,
250: x_p3_tot,
251: x_p4_tot
252: from pa_budget_lines_v
253: where budget_version_id = x_budget_version_id
254: and task_id = x_task_id
255: and project_id = x_project_id
256: and start_date between x_start_date

Line 298: from pa_budget_lines_v

294: 'RE', nvl(revenue,0),
295: 'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
296: 0) )
297: into x_grand_tot
298: from pa_budget_lines_v
299: where budget_version_id = x_budget_version_id
300: and task_id = x_task_id
301: and project_id = x_project_id
302: and start_date between x_start_date