DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_SALES_LEAD_OPPORTUNITY

Line 573: FROM as_sales_lead_opportunity

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,

Line 1606: FROM as_sales_lead_opportunity

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:

Line 2416: FROM as_sales_lead_opportunity

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