APPS.IGS_AD_IMP_001 dependencies on IGS_PE_MATCH_SETS_ALL

Line 605: l_match_set_name igs_pe_match_sets_all.match_set_name%TYPE;

601: l_schema VARCHAR2(30);
602:
603: l_batch_desc igs_ad_imp_batch_det.batch_desc%TYPE;
604: l_source_type igs_pe_src_types_all.system_source_type%TYPE;
605: l_match_set_name igs_pe_match_sets_all.match_set_name%TYPE;
606: l_interface_run_id igs_ad_interface_ctl.interface_run_id%TYPE;
607: l_rowid VARCHAR2(100);
608: l_cnt_dup_process_run NUMBER;
609: l_err_msg VARCHAR2(4000);

Line 652: FROM igs_pe_match_sets_all

648: AND NVL(closed_ind,'N') = 'N'
649: AND system_source_type IN ('APPLICATION', 'TEST_RESULTS', 'PROSPECT_LIST', 'PROSPECT_SS_WEB_INQUIRY', 'TRANSCRIPT');
650:
651: SELECT match_set_name INTO l_match_set_name
652: FROM igs_pe_match_sets_all
653: WHERE match_set_id = p_match_set_id
654: AND closed_ind = 'N';
655: EXCEPTION
656: WHEN OTHERS THEN