DBA Data[Home] [Help]

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_MTCH_SET_DATA_ALL

Line 3036: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS

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:

Line 3038: FROM igs_pe_mtch_set_data_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:
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,