APPS.PV_OPP_MATCH_PUB dependencies on AS_LEADS_ALL

Line 934: FROM as_leads_all a,

930: -- Cursor for retrieving location_id for the opportunity (customer).
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

Line 1606: FROM as_leads_all asla

1602: END IF;
1603:
1604: SELECT INCUMBENT_PARTNER_PARTY_ID
1605: INTO l_preferred_partner_party_id
1606: FROM as_leads_all asla
1607: WHERE lead_id = p_entity_id;
1608:
1609: -- ------------------------------------------------------------------------------
1610: -- Find out if the preferred partner is already in x_partner_tbl partner list.