APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_METH_STAGE_MAP

Line 445: --and exists (select 1 from as_sales_meth_stage_map b, as_sales_stages_all_b c

441: and asmb.sales_methodology_id = X_Sales_Methodology_ID;
442:
443: -- ckapoor 05/11/04 bug 3621389 - change validation sql for sales methodology id
444:
445: --and exists (select 1 from as_sales_meth_stage_map b, as_sales_stages_all_b c
446: -- where asmb.sales_methodology_id = b.sales_methodology_id
447: -- and b.sales_stage_id = c.sales_stage_id
448: -- and c.applicability in ('LEAD', 'BOTH')
449: -- and c.enabled_flag = 'Y'

Line 519: FROM AS_SALES_METH_STAGE_MAP asms

515: -- This cursor validates if the sales stage corresponds to the sales meth id passed in
516:
517: CURSOR C_Sales_Stage_Exists(X_Sales_Methodology_ID NUMBER, X_Sales_Stage_ID NUMBER) IS
518: SELECT 'X'
519: FROM AS_SALES_METH_STAGE_MAP asms
520: , AS_SALES_STAGES_ALL_B assa
521: WHERE asms.sales_stage_id = assa.sales_stage_id
522: AND TRUNC(NVL(assa.start_date_active, SYSDATE)) <= TRUNC(SYSDATE)
523: AND TRUNC(NVL(assa.end_date_active, SYSDATE)) >= TRUNC(SYSDATE)

Line 3344: FROM AS_SALES_METH_STAGE_MAP asms

3340:
3341: SELECT sales_stage_id
3342: FROM (
3343: SELECT asms.sales_stage_id
3344: FROM AS_SALES_METH_STAGE_MAP asms
3345: , AS_SALES_STAGES_ALL_B assa
3346: WHERE asms.sales_stage_id = assa.sales_stage_id
3347: AND TRUNC(NVL(assa.start_date_active, SYSDATE)) <= TRUNC(SYSDATE)
3348: AND TRUNC(NVL(assa.end_date_active, SYSDATE)) >= TRUNC(SYSDATE)