DBA Data[Home] [Help]

APPS.GMS_REPORT_SF270 dependencies on GMS_CDL_BURDEN_DETAIL_V

Line 127: gms_cdl_burden_detail_v bv

123: cursor c_sum_burden is
124: Select sum(nvl(bv.burden_cost,0))
125: from pa_expenditure_items_all ei,
126: pa_cost_distribution_lines_all c,
127: gms_cdl_burden_detail_v bv
128: where c.gl_date between X_Report_Start_Date and X_Report_End_Date
129: and c.expenditure_item_id = ei.expenditure_item_id
130: and bv.award_id = X_Award_Id
131: and c.line_type = 'R'

Line 149: FROM gms_cdl_burden_detail_v bv,

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