APPS.GMS_REPORT_SF270 dependencies on GMS_BUDGET_VERSIONS

Line 113: from gms_budget_versions gbv

109: and g.expenditure_item_id = c.expenditure_item_id
110: and c.line_type = 'R'
111: and ei.system_linkage_function <> 'BTC' -- Put the correct code for system linkage function
112: and ei.project_id in ( select gbv.project_id
113: from gms_budget_versions gbv
114: where gbv.budget_type_code = 'AC'
115: and gbv.budget_status_code in ('S','W' )
116: and gbv.award_id = X_Award_Id )
117: ;

Line 137: from gms_budget_versions gbv

133: and bv.expenditure_item_id = c.expenditure_item_id
134: and bv.line_num = c.line_num
135: and bv.project_id = ei.project_id
136: and ei.project_id in ( select gbv.project_id
137: from gms_budget_versions gbv
138: where gbv.budget_type_code = 'AC'
139: and gbv.budget_status_code in ('S','W' )
140: and gbv.award_id = X_Award_Id )
141: and bv.project_id in ( select gbv.project_id

Line 142: from gms_budget_versions gbv

138: where gbv.budget_type_code = 'AC'
139: and gbv.budget_status_code in ('S','W' )
140: and gbv.award_id = X_Award_Id )
141: and bv.project_id in ( select gbv.project_id
142: from gms_budget_versions gbv
143: where gbv.budget_type_code = 'AC'
144: and gbv.budget_status_code in ('S','W' )
145: and gbv.award_id = X_Award_Id ) ;
146: */

Line 150: gms_budget_versions gbv

146: */
147: cursor c_sum_burden is
148: Select sum(nvl(bv.burden_cost,0))
149: FROM gms_cdl_burden_detail_v bv,
150: gms_budget_versions gbv
151: WHERE bv.gl_date between X_Report_Start_Date and X_Report_End_Date
152: and bv.award_id = X_Award_Id
153: and bv.line_type = 'R'
154: and bv.system_linkage_function <> 'BTC' -- Put the correct code for system linkage function