APPS.GMS_REPORT_SF269 dependencies on GMS_AWARDS

Line 50: from gms_awards a,

46: cursor total_outlay_burden IS
47: Select
48: sum(nvl(bv.burden_cost,0)) burden_cost,
49: gcd.report_direct_flag report_direct_flag
50: from gms_awards a,
51: GMS_CDL_BURDEN_DETAIL_V bv,
52: pa_ind_cost_codes cd,
53: gms_ind_cost_codes gcd,
54: gms_allowable_expenditures ae

Line 136: FROM gms_awards

132: -- Cursor to fetch Report periods
133: CURSOR report_period_date_cur IS
134: SELECT GREATEST(x_report_start_date, start_date_active),
135: LEAST(x_report_end_date, end_date_active)
136: FROM gms_awards
137: WHERE award_id = x_award_id;
138:
139: -- Added for bug 2357578
140: -- Cursor to fetch Funding periods based on award

Line 144: FROM gms_awards

140: -- Cursor to fetch Funding periods based on award
141: CURSOR funding_period_date_cur IS
142: SELECT start_date_active,
143: end_date_active
144: FROM gms_awards
145: WHERE award_id = x_award_id;
146:
147: l_set_of_books_id number;
148: l_expenditure_item_id NUMBER := NULL;

Line 294: -- 2. Get document number(Funding Source Award Number) from gms_awards

290: where award_id = X_Award_Id
291: and status_code = 'O';
292: End;
293:
294: -- 2. Get document number(Funding Source Award Number) from gms_awards
295:
296: Begin
297: select funding_source_award_number
298: into l_document_number

Line 299: from GMS_AWARDS

295:
296: Begin
297: select funding_source_award_number
298: into l_document_number
299: from GMS_AWARDS
300: where award_id = X_Award_Id;
301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: NULL;

Line 432: gms_awards a,

428: Select
429: sum(nvl(bv.burden_cost,0)) burden_cost
430: into l_allowed_cost_base_burden
431: from gms_allowable_expenditures ae,
432: gms_awards a,
433: GMS_CDL_BURDEN_DETAIL_V bv,
434: gms_award_distributions g,
435: pa_cost_distribution_lines_all c,
436: pa_expenditure_items ei