APPS.PV_OPP_MATCH_PUB dependencies on HZ_LOCATIONS
Line 936: hz_locations l
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
940: b.location_id = l.location_id AND