DBA Data[Home] [Help]

APPS.GMS_BUDGET_MATRIX dependencies on GMS_BUDGET_LINES_V

Line 163: from gms_budget_lines_v

159: decode(x_amt_type,'RC',nvl(raw_cost,0),'BC',nvl(burdened_cost,0),'RE',nvl(revenue,0),
160: 'QU',nvl(quantity,0),0))
161: into x_tot,
162: x_tot2
163: from gms_budget_lines_v
164: where budget_version_id = x_budget_version_id
165: and task_id = x_task_id
166: and resource_list_member_id = x_RLMI
167: and project_id = x_project_id

Line 219: from gms_budget_lines_v

215: into x_p1_tot,
216: x_p2_tot,
217: x_p3_tot,
218: x_p4_tot
219: from gms_budget_lines_v
220: where budget_version_id = x_budget_version_id
221: and task_id = x_task_id
222: and project_id = x_project_id
223: and start_date between x_start_date

Line 245: from gms_budget_lines_v

241: 'RE', nvl(revenue,0),
242: 'QU', decode(track_As_labor_flag,'Y',nvl(quantity,0),0 ),
243: 0) )
244: into x_grand_tot
245: from gms_budget_lines_v
246: where budget_version_id = x_budget_version_id
247: and task_id = x_task_id
248: and project_id = x_project_id
249: and start_date between x_start_date