DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_LEADS_ALL

Line 154: AS_LEADS_ALL OPP,

150: ,opp.attribute15
151:
152:
153: FROM
154: AS_LEADS_ALL OPP,
155: HZ_PARTIES PARTY,
156: AMS_P_SOURCE_CODES_V AMS1,
157: OE_LOOKUPS ASOCHANNELS,
158: AS_SALES_STAGES_ALL_B STGB,

Line 714: From AS_LEADS_ALL

710: ,attribute14
711: ,attribute15
712: ,parent_project
713: -- ,FND_API.G_MISS_NUM -- ,security_group_id
714: From AS_LEADS_ALL
715: Where lead_id = X_Opportunity_Id;
716:
717: CURSOR C_Get_Sales_lead_lines (X_Sales_Lead_Id NUMBER) IS
718: SELECT sales_lead_line_id

Line 1742: From AS_LEADS_ALL

1738: ,attribute14
1739: ,attribute15
1740: ,parent_project
1741: -- ,FND_API.G_MISS_NUM -- ,security_group_id
1742: From AS_LEADS_ALL
1743: Where lead_id = X_Opportunity_Id;
1744:
1745: l_api_name CONSTANT VARCHAR2(30) := 'Link_Lead_To_Opportunity';
1746: l_api_version_number CONSTANT NUMBER := 2.0;

Line 2409: FROM as_leads_all

2405: -- end 102700 FFANG
2406:
2407: CURSOR C_Get_Opportunity(X_Lead_Id NUMBER) IS
2408: SELECT last_update_date
2409: FROM as_leads_all
2410: WHERE lead_id = X_Lead_Id;
2411:
2412: -- ffang 020301, for checking if the linking has already existed.
2413: /*