DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_METHODOLOGY_B

Line 435: from as_sales_methodology_b asmb

431: -- corresponds to an active sales methodology with an active sales stage associated with it
432:
433: CURSOR C_Methodology_Exists (X_Sales_Methodology_ID NUMBER) IS
434: select 'X'
435: from as_sales_methodology_b asmb
436: --, as_sales_methodology_tl asmt
437: where trunc(nvl(asmb.start_date_active, sysdate)) <= trunc(sysdate)
438: and trunc(nvl(asmb.end_date_active, sysdate)) >= trunc(sysdate)
439: --and asmb.sales_methodology_id = asmt.sales_methodology_id