APPS.AST_ASN_INTEROP dependencies on AS_SALES_STAGES_ALL_VL

Line 139: from as_sales_stages_all_vl

135: where sales_lead_id = p_sales_lead_id;
136:
137: cursor c_sales_stage(p_sales_stage_id NUMBER) is
138: select applicability
139: from as_sales_stages_all_vl
140: where sales_stage_id = p_sales_stage_id;
141:
142: cursor c_first_sales_stage(p_sales_method_id NUMBER) is
143: SELECT stage.sales_stage_id

Line 144: FROM as_sales_stages_all_vl stage, as_sales_meth_stage_map map1

140: where sales_stage_id = p_sales_stage_id;
141:
142: cursor c_first_sales_stage(p_sales_method_id NUMBER) is
143: SELECT stage.sales_stage_id
144: FROM as_sales_stages_all_vl stage, as_sales_meth_stage_map map1
145: WHERE stage.sales_stage_id = map1.sales_stage_id
146: AND nvl(stage.applicability,'BOTH') in ('OPPORTUNITY', 'BOTH')
147: AND nvl(stage.ENABLED_FLAG,'Y') = 'Y'
148: AND trunc(sysdate) between trunc(nvl(START_DATE_ACTIVE,sysdate))