APPS.IGS_PE_DUP_PERSON dependencies on IGS_PE_SRC_TYPES

Line 43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,

39: l_match_found BOOLEAN := FALSE;
40: l_match_set_id igs_pe_match_sets_all.match_set_id%TYPE;
41:
42: -- Cursor to check value of Profile Option: Duplicate Match Criteria
43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,
45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS
46: SELECT match.match_set_id
47: FROM igs_pe_match_sets_all match,igs_pe_src_types src

Line 47: FROM igs_pe_match_sets_all match,igs_pe_src_types src

43: CURSOR c_match_set_criteria (cp_system_source_type igs_pe_src_types.system_source_type%TYPE,
44: cp_match_set_id igs_pe_match_sets_all.match_set_id%TYPE,
45: cp_closed_ind igs_pe_match_sets_all.closed_ind%TYPE) IS
46: SELECT match.match_set_id
47: FROM igs_pe_match_sets_all match,igs_pe_src_types src
48: WHERE src.system_source_type = cp_system_source_type AND
49: src.source_type_id = match.source_type_id AND
50: match.match_set_id = cp_match_set_id AND
51: match.closed_ind = cp_closed_ind;