DBA Data[Home] [Help]

APPS.IGS_AD_IMP_002 dependencies on IGS_PE_MATCH_SETS_ALL

Line 3031: CURSOR c_get_global_var(cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE) IS

3027: l_default_date DATE;
3028: l_person_id igs_ad_interface.person_id%TYPE;
3029:
3030: -- cursor to populate global variable g_partial_if_null and g_primary_addr_flag
3031: CURSOR c_get_global_var(cp_match_set_id igs_pe_match_sets_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:

Line 3033: FROM igs_pe_match_sets_all

3029:
3030: -- cursor to populate global variable g_partial_if_null and g_primary_addr_flag
3031: CURSOR c_get_global_var(cp_match_set_id igs_pe_match_sets_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