APPS.IGR_GEN_002 dependencies on IGS_AD_ACADHIS_INT_ALL

Line 164: DELETE igs_ad_acadhis_int_all WHERE interface_id = p_interface_id;

160: DELETE igr_i_lines_int WHERE interface_inq_appl_id IN
161: (SELECT interface_inq_appl_id FROM igr_i_appl_int WHERE interface_id = p_interface_id);
162: DELETE igr_i_appl_int WHERE interface_id = p_interface_id;
163:
164: DELETE igs_ad_acadhis_int_all WHERE interface_id = p_interface_id;
165: DELETE igs_ad_contacts_int_all WHERE interface_id = p_interface_id;
166: DELETE igs_pe_race_int WHERE interface_id = p_interface_id;
167: DELETE igs_ad_stat_int WHERE interface_id = p_interface_id;
168: COMMIT;