APPS.PV_OPP_MATCH_PUB dependencies on HZ_PARTY_SITES

Line 935: hz_party_sites b,

931: -- -------------------------------------------------------------------------
932: CURSOR lc_get_location_id (p_entity_id IN NUMBER) IS
933: SELECT b.location_id
934: FROM as_leads_all a,
935: hz_party_sites b,
936: hz_locations l
937: WHERE a.lead_id = p_entity_id AND
938: a.customer_id = b.party_id AND
939: b.party_site_id = a.address_id AND