APPS.IGS_AD_IMP_009 dependencies on IGS_AD_IMP_MATCHES_PA_V

Line 627: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pa_v.interface_id%TYPE,

623: l_debug_str VARCHAR2(2000);
624: l_enable_log VARCHAR2(1);
625: l_request_id NUMBER;
626:
627: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pa_v.interface_id%TYPE,
628: cp_c_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE)
629: IS
630: SELECT *
631: FROM igs_ad_imp_matches_pa_v

Line 628: cp_c_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE)

624: l_enable_log VARCHAR2(1);
625: l_request_id NUMBER;
626:
627: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pa_v.interface_id%TYPE,
628: cp_c_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE)
629: IS
630: SELECT *
631: FROM igs_ad_imp_matches_pa_v
632: WHERE interface_id = cp_d_interface_id

Line 631: FROM igs_ad_imp_matches_pa_v

627: CURSOR imp_person_cur(cp_d_interface_id igs_ad_imp_matches_pa_v.interface_id%TYPE,
628: cp_c_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE)
629: IS
630: SELECT *
631: FROM igs_ad_imp_matches_pa_v
632: WHERE interface_id = cp_d_interface_id
633: AND
634: ( addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y');
635:

Line 638: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS

634: ( addr_type = cp_c_addr_type OR addr_type IS NULL OR Igs_Pe_Identify_Dups.g_primary_addr_flag = 'Y');
635:
636:
637: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
638: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
639: SELECT PS.party_site_id
640: FROM hz_party_sites PS,hz_party_site_uses PSU
641: WHERE PS.party_site_id = PSU.party_site_id AND
642: PS.party_id = cp_person_id AND

Line 989: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS

985: AND (person_id_type = cp_c_person_id_type OR person_id_type IS NULL);
986:
987:
988: CURSOR party_site_cur(cp_person_id igs_pe_person.person_id%TYPE,
989: cp_addr_type igs_ad_imp_matches_pa_v.addr_type%TYPE) IS
990: SELECT PS.party_site_id
991: FROM hz_party_sites PS,hz_party_site_uses PSU
992: WHERE PS.party_site_id = PSU.party_site_id AND
993: PS.party_id = cp_person_id AND