APPS.IGS_AD_IMP_001 dependencies on IGS_AD_TEST_SEGS_INT

Line 273: AND EXISTS (SELECT 1 FROM igs_ad_test_segs_int WHERE status <> '1' AND interface_test_id = tst.interface_test_id);

269: error_code = 'E347',
270: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
271: WHERE status = '1'
272: AND interface_run_id = p_interface_run_id
273: AND EXISTS (SELECT 1 FROM igs_ad_test_segs_int WHERE status <> '1' AND interface_test_id = tst.interface_test_id);
274: COMMIT;
275:
276: --Dynamic Code block to be executed when IGR functionality is enabled.
277: IF fnd_profile.value('IGS_RECRUITING_ENABLED') = 'Y' THEN