APPS.AS_SALES_LEAD_OPP_PVT dependencies on AS_SALES_STAGES_ALL_VL

Line 3570: from as_sales_stages_all_vl

3566: IS
3567:
3568: cursor c_sales_stage(p_sales_stage_id NUMBER) is
3569: select applicability
3570: from as_sales_stages_all_vl
3571: where sales_stage_id = p_sales_stage_id;
3572:
3573: cursor c_first_sales_stage(p_sales_method_id NUMBER) is
3574: SELECT stage.sales_stage_id

Line 3575: FROM as_sales_stages_all_vl stage, as_sales_meth_stage_map map1

3571: where sales_stage_id = p_sales_stage_id;
3572:
3573: cursor c_first_sales_stage(p_sales_method_id NUMBER) is
3574: SELECT stage.sales_stage_id
3575: FROM as_sales_stages_all_vl stage, as_sales_meth_stage_map map1
3576: WHERE stage.sales_stage_id = map1.sales_stage_id
3577: AND nvl(stage.applicability,'BOTH') in ('OPPORTUNITY', 'BOTH')
3578: AND nvl(stage.ENABLED_FLAG,'Y') = 'Y'
3579: AND trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))