APPS.GMS_REPORT_SF272 dependencies on GMS_AWARDS

Line 185: FROM gms_awards

181: -- Cursor to fetch Report periods
182: CURSOR report_period_date_cur IS
183: SELECT GREATEST(X_Report_Start_Date, start_date_active),
184: LEAST(X_Report_End_Date, end_date_active)
185: FROM gms_awards
186: WHERE award_id = X_Award_Id;
187:
188: L_Report_Start_Date gms_272_history.report_start_date%type;
189: L_Report_End_Date gms_272_history.report_end_date%type;

Line 219: GMS_AWARDS

215: funding_source_award_number
216: into
217: X_Document_Number
218: from
219: GMS_AWARDS
220: where
221: award_id = X_Award_Id;
222: EXCEPTION
223: WHEN NO_DATA_FOUND THEN