21: from dual
22: where exists
23: (
24: select hzu.party_site_use_id 25: from hz_party_sites hzs, 26: hz_party_site_uses hzu
27: where hzs.party_id in (p_partner_party_id, p_contact_party_id)
28: and hzu.party_site_id = hzs.party_site_id
29: and hzu.site_use_type = 'BILL_TO'