APPS.IGS_AD_IMP_001 dependencies on IGS_PE_SRC_TYPES_ALL

Line 604: l_source_type igs_pe_src_types_all.system_source_type%TYPE;

600: l_industry VARCHAR2(5);
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;

Line 646: FROM igs_pe_src_types_all

642: FROM igs_ad_imp_batch_det
643: WHERE batch_id = p_batch_id ;
644:
645: SELECT system_source_type INTO l_source_type
646: FROM igs_pe_src_types_all
647: WHERE source_type_id = p_source_type_id
648: AND NVL(closed_ind,'N') = 'N'
649: AND system_source_type IN ('APPLICATION', 'TEST_RESULTS', 'PROSPECT_LIST', 'PROSPECT_SS_WEB_INQUIRY', 'TRANSCRIPT');
650: