3032: SELECT partial_if_null,primary_addr_flag, exclude_inactive_ind
3033: FROM igs_pe_match_sets_all
3034: WHERE match_set_id = cp_match_set_id;
3035:
3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
3037: SELECT data_element, drop_if_null, partial_include, exact_include
3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:
3034: WHERE match_set_id = cp_match_set_id;
3035:
3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
3037: SELECT data_element, drop_if_null, partial_include, exact_include
3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:
3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,