APPS.IGS_PE_IDENTIFY_DUPS dependencies on IGS_PE_PERSON_BASE_V

Line 812: l_person_id igs_pe_person_base_v.person_id%TYPE;

808: l_rowid VARCHAR2(30);
809: l_near_mtch_ind igs_ad_imp_near_mtch_all.near_mtch_id%TYPE;
810: l_count NUMBER(7) := 0;
811: l_stmt VARCHAR2(2000);
812: l_person_id igs_pe_person_base_v.person_id%TYPE;
813:
814: TYPE dup_check_cur IS REF CURSOR;
815: dup_check_rec dup_check_cur;
816: l_cursor_id NUMBER(15);

Line 840: fnd_dsql.add_text('SELECT person_id FROM igs_pe_person_base_v WHERE UPPER(first_name) =UPPER(');

836: END;
837:
838: fnd_dsql.init;
839:
840: fnd_dsql.add_text('SELECT person_id FROM igs_pe_person_base_v WHERE UPPER(first_name) =UPPER(');
841: fnd_dsql.add_bind(P_REL_DUP_REC.FIRST_NAME);
842: fnd_dsql.add_text(') AND UPPER (last_name) = UPPER (');
843: fnd_dsql.add_bind(P_REL_DUP_REC.SURNAME);
844: fnd_dsql.add_text(') AND ( 1 = 2 OR ');