DBA Data[Home] [Help]

APPS.IGS_PE_DUP_PERSON dependencies on IGS_PE_MTCH_SET_DATA_ALL

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

58:
59: partial_if_null_rec c_get_partial_if_null%ROWTYPE;
60:
61: -- cursor to populate the PL/SQL tables
62: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
63: SELECT data_element, drop_if_null, partial_include, exact_include
64: FROM igs_pe_mtch_set_data_all
65: WHERE match_set_id = cp_match_set_id;
66:

Line 64: FROM igs_pe_mtch_set_data_all

60:
61: -- cursor to populate the PL/SQL tables
62: CURSOR c_matchset_data_cur(cp_match_set_id igs_pe_mtch_set_data_all.match_set_id%TYPE) IS
63: SELECT data_element, drop_if_null, partial_include, exact_include
64: FROM igs_pe_mtch_set_data_all
65: WHERE match_set_id = cp_match_set_id;
66:
67: matchset_data_rec c_matchset_data_cur%ROWTYPE;
68: l_count_exact NUMBER;