162: -- Cursor to fetch Report periods
163: CURSOR report_period_date_cur IS
164: SELECT GREATEST(X_Report_Start_Date, start_date_active),
165: LEAST(X_Report_End_Date, end_date_active)
166: FROM gms_awards
167: WHERE award_id = X_Award_Id;
168:
169: L_Report_Start_Date gms_270_history.report_start_date%type;
170: L_Report_End_Date gms_270_history.report_end_date%type;
203: funding_source_award_number
204: into
205: X_Document_Number
206: from
207: GMS_AWARDS
208: where
209: award_id = X_Award_Id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN