APPS.IGR_GEN_002 dependencies on IGR_I_LINES_INT

Line 160: DELETE igr_i_lines_int WHERE interface_inq_appl_id IN

156: -- which correspond to that Inquiry should be deleted .
157: DELETE igs_ad_interface_all WHERE interface_id = p_interface_id;
158: DELETE igs_ad_addr_int_all WHERE interface_id = p_interface_id;
159:
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;