569: IS
570:
571: CURSOR C_lead_link_Exists (X_Sales_Lead_Id NUMBER, X_Opportunity_Id NUMBER) IS
572: SELECT 'X'
573: FROM as_sales_lead_opportunity
574: WHERE sales_lead_id = X_Sales_Lead_Id
575: AND opportunity_id = X_Opportunity_Id;
576:
577: CURSOR C_Sales_Owner_Check (X_Identity_Salesforce_Id NUMBER,
1602: --NULL;
1603:
1604: CURSOR C_lead_link_Exists (X_Sales_Lead_Id NUMBER, X_Opportunity_Id NUMBER) IS
1605: SELECT 'X'
1606: FROM as_sales_lead_opportunity
1607: WHERE sales_lead_id = X_Sales_Lead_Id
1608: AND opportunity_id = X_Opportunity_Id;
1609:
1610:
2412: -- ffang 020301, for checking if the linking has already existed.
2413: /*
2414: CURSOR C_lead_link_Exists (X_Sales_Lead_Id NUMBER) IS
2415: SELECT 'X'
2416: FROM as_sales_lead_opportunity
2417: WHERE sales_lead_id = X_Sales_Lead_Id ;
2418: */
2419:
2420: -- ffang 051602, bug 2278318, copy lead's sales team to oppty