APPS.AS_SALES_LEADS_PVT dependencies on AS_SALES_STAGES_ALL_B

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 520: , AS_SALES_STAGES_ALL_B assa

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)
524: AND sales_methodology_id = X_Sales_Methodology_ID

Line 3345: , AS_SALES_STAGES_ALL_B assa

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)
3349: AND sales_methodology_id = X_Sales_Meth_ID