APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_NOTIFICATIONS

Line 503: SELECT 1 FROM gms_notifications

499: retcode OUT NOCOPY VARCHAR2 ,
500: errbuff OUT NOCOPY VARCHAR2
501: ) AS
502: CURSOR notification_lock IS
503: SELECT 1 FROM gms_notifications
504: WHERE award_id=p_award_Id
505: FOR UPDATE NOWAIT;
506:
507: CURSOR lock_installments IS

Line 521: DELETE FROM gms_notifications WHERE award_id= p_award_id;

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);
525: DELETE FROM gms_personnel WHERE award_id =p_award_id;