APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_IMP_NEAR_MTCH_ALL

Line 97: DELETE FROM igs_ad_imp_near_mtch_all

93: -- 2. Then all records with match_ind = '22' (ie., reviewed) are made status '1' and the respective processes are
94: -- called for further processing
95:
96: -- Delete all the records before processing for duplicate check.
97: DELETE FROM igs_ad_imp_near_mtch_all
98: WHERE interface_id IN
99: (SELECT interface_id FROM igs_ad_interface_all
100: WHERE interface_run_id = l_interface_run_id AND
101: status='2');