APPS.IGR_GEN_002 dependencies on IGS_AD_INTERFACE_ALL
Line 157: DELETE igs_ad_interface_all WHERE interface_id = p_interface_id;
153:
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);