[Home] [Help]
446: where party_id = p_person_party_id;
447:
448: cursor get_email_from_party_rel (p_person_party_id in hz_parties.party_id%type) is
449: select hzp_rel.email_address
450: from hz_parties hzp_rel, hz_relationships hzr
451: where hzr.subject_id = p_person_party_id
452: and hzr.party_id = hzp_rel.party_id
453: and hzp_rel.email_address is not null;
454: