APPS.GMS_REPORT_SF425 dependencies on GMS_AWARDS

Line 42: from GMS_AWARDS

38: CURSOR award_details_csr (p_award_id IN NUMBER) IS
39: select
40: end_date_active , -- Check with SHweta if this is correct
41: start_date_active
42: from GMS_AWARDS
43: where award_id = p_award_id;
44:
45: CURSOR c_sum_amount (
46: p_award_id IN NUMBER,

Line 124: gms_awards a,

120: Select
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