APPS.GMS_REPORT_SF272 dependencies on GMS_BUDGET_VERSIONS

Line 134: from gms_budget_versions gbv

130: and g.expenditure_item_id = c.expenditure_item_id
131: and c.line_type = 'R'
132: and ei.system_linkage_function <> 'BTC' -- Put the correct code for system linkage function
133: and ei.project_id in ( select gbv.project_id
134: from gms_budget_versions gbv
135: where gbv.budget_type_code = 'AC'
136: and gbv.budget_status_code in ('S','W' )
137: and gbv.award_id = X_Award_Id )
138: ;

Line 156: from gms_budget_versions gbv

152: and bv.expenditure_item_id = c.expenditure_item_id
153: and bv.line_num = c.line_num
154: and bv.project_id = ei.project_id
155: and ei.project_id in ( select gbv.project_id
156: from gms_budget_versions gbv
157: where gbv.budget_type_code = 'AC'
158: and gbv.budget_status_code in ('S','W' )
159: and gbv.award_id = X_Award_Id )
160: and bv.project_id in ( select gbv.project_id

Line 161: from gms_budget_versions gbv

157: where gbv.budget_type_code = 'AC'
158: and gbv.budget_status_code in ('S','W' )
159: and gbv.award_id = X_Award_Id )
160: and bv.project_id in ( select gbv.project_id
161: from gms_budget_versions gbv
162: where gbv.budget_type_code = 'AC'
163: and gbv.budget_status_code in ('S','W' )
164: and gbv.award_id = X_Award_Id ) ;
165: */

Line 169: gms_budget_versions gbv

165: */
166: cursor c_sum_burden is
167: Select sum(nvl(bv.burden_cost,0))
168: FROM gms_cdl_burden_detail_v bv,
169: gms_budget_versions gbv
170: WHERE bv.gl_date between X_Report_Start_Date and X_Report_End_Date
171: and bv.award_id = X_Award_Id
172: and bv.line_type = 'R'
173: and bv.system_linkage_function <> 'BTC' -- Put the correct code for system linkage function