APPS.OE_CNCL_VALIDATE_LINE dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 361: FROM oe_workflow_assignments a

357: --l_old_wf_item_type VARCHAR2(30);
358:
359: CURSOR find_LineProcessname IS
360: SELECT 'EXISTS'
361: FROM oe_workflow_assignments a
362: WHERE a.line_type_id = p_line_rec.line_type_id
363: AND nvl(a.item_type_code,nvl(l_new_wf_item_type,'-99')) = nvl(l_new_wf_item_type,'-99')
364: AND a.process_name = lprocessname
365: AND a.order_type_id = lorder_type_id

Line 377: FROM oe_workflow_assignments a

373:
374:
375: Cursor find_config_assign is
376: SELECT 'EXISTS'
377: FROM oe_workflow_assignments a
378: WHERE a.line_type_id = p_line_rec.line_type_id
379: AND a.item_type_code = l_new_wf_item_type
380: AND a.order_type_id = lorder_type_id ;
381: