APPS.IGS_AD_IMP_001 dependencies on IGS_UC_QUAL_INTS

Line 300: OR EXISTS (SELECT 1 FROM igs_uc_qual_ints WHERE status <> '1' AND interface_id = ad.interface_id)

296: AND (
297: EXISTS (SELECT 1 FROM igs_ad_apl_int WHERE status <> '1' AND interface_id = ad.interface_id)
298: OR EXISTS (SELECT 1 FROM igs_ad_test_int WHERE status <> '1' AND interface_id = ad.interface_id)
299: OR EXISTS (SELECT 1 FROM igs_ad_recruit_int WHERE status <> '1' AND interface_id = ad.interface_id)
300: OR EXISTS (SELECT 1 FROM igs_uc_qual_ints WHERE status <> '1' AND interface_id = ad.interface_id)
301: OR EXISTS (SELECT 1 FROM igs_ad_acadhis_int_all WHERE status <> '1' AND interface_id = ad.interface_id)
302: OR EXISTS (SELECT 1 FROM igs_pe_cred_int WHERE status <> '1' AND interface_id = ad.interface_id)
303: );
304: COMMIT;

Line 478: igs_uc_qual_ints qint

474: SELECT 1 INTO l_count1
475: FROM DUAL
476: WHERE EXISTS (SELECT 1
477: FROM igs_ad_interface int,
478: igs_uc_qual_ints qint
479: WHERE int.interface_id = qint.interface_id
480: AND int.source_type_id = p_source_type_id
481: AND int.batch_id = p_batch_id
482: AND int.status IN('1','4','2')