APPS.OE_VALIDATE_LINE dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 1170: FROM oe_workflow_assignments a

1166: lline_category_code VARCHAR2(30);
1167:
1168: CURSOR find_LineProcessname IS
1169: SELECT 'EXISTS'
1170: FROM oe_workflow_assignments a
1171: WHERE a.line_type_id = p_line_rec.line_type_id
1172: AND nvl(a.item_type_code,nvl(l_new_wf_item_type,'-99')) = nvl(l_new_wf_item_type,'-99')
1173: AND a.process_name = lprocessname
1174: AND a.order_type_id = lorder_type_id

Line 1186: FROM oe_workflow_assignments a

1182: WHERE header_id = p_line_rec.header_id ;
1183:
1184: Cursor find_config_assign is
1185: SELECT 'EXISTS'
1186: FROM oe_workflow_assignments a
1187: WHERE a.line_type_id = p_line_rec.line_type_id
1188: AND a.item_type_code = l_new_wf_item_type
1189: AND a.order_type_id = lorder_type_id
1190: AND sysdate between A.START_DATE_ACTIVE

Line 2232: FROM oe_workflow_assignments wf_assign,

2228: END IF;
2229:
2230: SELECT wf_assign.process_name
2231: INTO l_root
2232: FROM oe_workflow_assignments wf_assign,
2233: oe_order_headers header
2234: WHERE nvl(p_wfasgn_item_type ,'-99') = nvl(wf_assign.item_type_code,nvl(p_wfasgn_item_type,'-99'))
2235: AND header.header_id = p_header_id
2236: AND header.order_type_id = wf_assign.order_type_id