APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_DEFAULT_REPORTS

Line 520: DELETE FROM gms_default_reports WHERE award_id = p_award_id;

516: CLOSE lock_installments;
517: --For bug 2312564 : changed the order of execution of delete to avoid dnagling records in gms_Reports
518: DELETE FROM gms_reports WHERE installment_id in (select installment_id from gms_installments WHERE award_id =p_award_id);
519: DELETE FROM gms_installments WHERE award_id=p_award_id;
520: DELETE FROM gms_default_reports WHERE award_id = p_award_id;
521: DELETE FROM gms_notifications WHERE award_id= p_award_id;
522: DELETE FROM gms_awards_terms_conditions WHERE award_id=p_award_id;
523: -- DELETE FROM gms_reports WHERE installment_id in (select installment_id
524: -- from gms_installments WHERE award_id =p_award_id);