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
643: PSU.site_use_type = cp_addr_type;
644:
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
994: PSU.site_use_type = cp_addr_type;
995: