APPS.IGR_GEN_002 dependencies on IGS_AD_ADDR_INT_ALL

Line 158: DELETE igs_ad_addr_int_all WHERE interface_id = p_interface_id;

154: BEGIN
155: -- All The records in the below interface tables
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;