DBA Data[Home] [Help]

APPS.PV_MATCH_V2_PUB dependencies on HZ_PARTY_SITES

Line 217: hz_party_sites b,

213: BEGIN
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