APPS.IGS_PE_IDENTIFY_DUPS dependencies on IGS_AD_IMP_NEAR_MTCH_ALL

Line 809: l_near_mtch_ind igs_ad_imp_near_mtch_all.near_mtch_id%TYPE;

805: Who when What
806: */
807:
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:

Line 825: FROM igs_ad_imp_near_mtch_all

821: /* Delete from igs_ad_near_match_int all old occurances */
822: DECLARE
823: CURSOR tbh_cur IS
824: SELECT ROWID
825: FROM igs_ad_imp_near_mtch_all
826: WHERE interface_relations_id = P_REL_DUP_REC.INTERFACE_RELATIONS_ID;
827: tbh_rec tbh_cur%ROWTYPE;
828: BEGIN
829: OPEN tbh_cur;