DBA Data[Home] [Help]

APPS.GMS_REPORT_SF425 dependencies on GMS_CDL_BURDEN_DETAIL_V

Line 75: FROM gms_cdl_burden_detail_v bv,

71: p_award_id IN NUMBER,
72: p_report_start_date IN DATE,
73: p_report_end_date IN DATE) IS
74: Select sum(nvl(bv.burden_cost,0))
75: FROM gms_cdl_burden_detail_v bv,
76: gms_budget_versions gbv
77: WHERE --added by rkuttiya for bug 9117372
78: -- bv.gl_date between p_report_start_date and p_report_end_date
79: trunc(bv.gl_date) < trunc(p_report_end_date)

Line 125: GMS_CDL_BURDEN_DETAIL_V bv,

121: sum(nvl(bv.burden_cost,0)) burden_cost,
122: gcd.report_direct_flag report_direct_flag
123: from
124: gms_awards a,
125: GMS_CDL_BURDEN_DETAIL_V bv,
126: pa_ind_cost_codes cd,
127: gms_ind_cost_codes gcd,
128: gms_allowable_expenditures ae
129: where