DBA Data[Home] [Help]

APPS.GMS_REPORT_SF272 dependencies on GMS_CDL_BURDEN_DETAIL_V

Line 146: gms_cdl_burden_detail_v bv

142: cursor c_sum_burden is
143: Select sum(nvl(bv.burden_cost,0))
144: from pa_expenditure_items_all ei,
145: pa_cost_distribution_lines_all c,
146: gms_cdl_burden_detail_v bv
147: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
148: and c.expenditure_item_id = ei.expenditure_item_id
149: and bv.award_id = X_Award_Id
150: and c.line_type = 'R'

Line 168: FROM gms_cdl_burden_detail_v bv,

164: and gbv.award_id = X_Award_Id ) ;
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'