APPS.PV_MATCH_V3_PUB dependencies on AS_LEADS_ALL

Line 804: FROM as_leads_all a,

800: -- Cursor for retrieving location_id for the opportunity (customer).
801: -- -------------------------------------------------------------------------
802: CURSOR lc_get_location_id (p_entity_id IN NUMBER) IS
803: SELECT b.location_id
804: FROM as_leads_all a,
805: hz_party_sites b,
806: hz_locations l
807: WHERE a.lead_id = p_entity_id AND
808: a.customer_id = b.party_id AND

Line 1610: FROM as_leads_all asla

1606: l_api_version_number CONSTANT NUMBER := 1.0;
1607:
1608: CURSOR lc_get_incumbent_pt (pc_lead_id NUMBER) IS
1609: SELECT asla.INCUMBENT_PARTNER_PARTY_ID
1610: FROM as_leads_all asla
1611: WHERE asla.lead_id = pc_lead_id;
1612:
1613: l_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
1614: l_new_matched_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

Line 1766: FROM as_leads_all a,

1762:
1763: BEGIN
1764: SELECT b.location_id
1765: INTO l_customer_address.location_id
1766: FROM as_leads_all a,
1767: hz_party_sites b,
1768: hz_locations l
1769: WHERE a.lead_id = p_lead_id AND
1770: a.customer_id = b.party_id AND

Line 2090: FROM as_leads_all asla

2086: */
2087:
2088: CURSOR lc_get_incumbent_pt (pc_lead_id NUMBER) IS
2089: SELECT asla.INCUMBENT_PARTNER_PARTY_ID
2090: FROM as_leads_all asla
2091: WHERE asla.lead_id = pc_lead_id;
2092:
2093: CURSOR lc_get_recycled_flag(pc_lead_id NUMBER , pc_partner_id NUMBER)
2094: IS

Line 3472: FROM as_leads_all

3468: RETURN VARCHAR2
3469: AS
3470: CURSOR lc_incumbent_part (pc_lead_id NUMBER, pc_partner_id NUMBER) is
3471: SELECT 'Y'
3472: FROM as_leads_all
3473: WHERE lead_id = pc_lead_id
3474: AND incumbent_partner_party_id = pc_partner_id;
3475:
3476: l_pref_part_str VARCHAR2(1);