APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_LEAD_CONTACTS_ALL

Line 798: FROM AS_LEAD_CONTACTS_ALL

794: -- ffang 020601, for bug 1628894, check duplicate contact before calling
795: -- create_opp_contact
796: CURSOR c_check_dup_contact (x_contact_party_id NUMBER) IS
797: SELECT 'X'
798: FROM AS_LEAD_CONTACTS_ALL
799: WHERE contact_party_id = x_contact_party_id
800: and lead_id = p_opportunity_id;
801: l_dup_contact VARCHAR2(1);
802: -- end ffang 020601

Line 1358: -- existed in as_lead_contacts_all, if not then copy values.

1354: /*
1355: For C_SL_Contacts_Rec In C_Get_Sales_lead_Contacts(P_Sales_Lead_Id) Loop
1356:
1357: -- ffang 020601, for bug 1628894, check if contact_party_id already
1358: -- existed in as_lead_contacts_all, if not then copy values.
1359: OPEN c_check_dup_contact (C_SL_Contacts_Rec.contact_party_id);
1360: FETCH c_check_dup_contact INTO l_dup_contact;
1361:
1362: IF c_check_dup_contact%NOTFOUND THEN