DBA Data[Home] [Help]

APPS.IGS_PE_IDENTIFY_DUPS dependencies on IGS_AD_INTERFACE

Line 75: INTERFACE_ID igs_ad_interface.interface_id%TYPE,

71: x_select_clause IN OUT NOCOPY VARCHAR2
72: );
73: -- Procedure to find duplicate match for Related Person during import
74: TYPE r_record_dup_rel IS RECORD(
75: INTERFACE_ID igs_ad_interface.interface_id%TYPE,
76: INTERFACE_RELATIONS_ID igs_ad_relations_int.interface_relations_id%TYPE,
77: SURNAME igs_ad_relations_int.surname%TYPE,
78: FIRST_NAME igs_Ad_relations_int.given_names%TYPE,
79: GENDER igs_ad_relations_int.sex%TYPE,

Line 81: BATCH_ID igs_ad_interface.batch_id%TYPE,

77: SURNAME igs_ad_relations_int.surname%TYPE,
78: FIRST_NAME igs_Ad_relations_int.given_names%TYPE,
79: GENDER igs_ad_relations_int.sex%TYPE,
80: BIRTH_DATE igs_ad_relations_int.birth_dt%TYPE,
81: BATCH_ID igs_ad_interface.batch_id%TYPE,
82: MATCH_SET_ID igs_pe_match_sets.match_set_id%TYPE);
83:
84: r_record_dup_rel_rec r_record_dup_rel;
85: