214: SELECT b.location_id
215: INTO l_customer_address.location_id
216: FROM as_leads_all a,
217: hz_party_sites b, 218: hz_locations l 219: WHERE a.lead_id = p_lead_id AND
220: a.customer_id = b.party_id AND
221: b.party_site_id = a.address_id AND
222: b.location_id = l.location_id AND