APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_AWARDS_CONTACTS

Line 527: DELETE FROM gms_awards_contacts 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);
525: DELETE FROM gms_personnel WHERE award_id =p_award_id;
526: DELETE FROM gms_reference_numbers WHERE award_id=p_award_id;
527: DELETE FROM gms_awards_contacts WHERE award_id=p_award_id;
528: DELETE FROM pa_credit_receivers WHERE project_id= p_award_Id;
529: -- Added the following delete statement for bug 2097676 :Multiple Indirect Cost schedules
530: DELETE FROM gms_override_schedules WHERE award_id=p_award_id;
531: retcode :='S';