APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_PERSONNEL

Line 525: DELETE FROM gms_personnel 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);
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