APPS.IGR_GEN_002 dependencies on IGR_I_APPL_INT

Line 161: (SELECT interface_inq_appl_id FROM igr_i_appl_int WHERE interface_id = p_interface_id);

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;
165: DELETE igs_ad_contacts_int_all WHERE interface_id = p_interface_id;

Line 162: DELETE igr_i_appl_int 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;
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;