APPS.OE_ORDER_WF_UTIL dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 42: from oe_workflow_assignments wf_assign,

38: trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate) to fix bug 3108864 */
39:
40: CURSOR find_HdrProcessname(itemkey varchar2) is
41: select wf_assign.process_name
42: from oe_workflow_assignments wf_assign,
43: oe_order_headers_all header
44: where header.header_id = to_number(itemkey)
45: and header.order_type_id = wf_assign.order_type_id
46: and sysdate >= wf_assign.start_date_active

Line 54: FROM oe_workflow_assignments wf_assign,

50: /* NEED UPGRADE ON NEW COLUMN? */
51:
52: CURSOR find_LineProcessname is
53: SELECT wf_assign.process_name
54: FROM oe_workflow_assignments wf_assign,
55: oe_order_headers_all header
56: WHERE nvl(p_wfasgn_item_type,'-99') =
57: nvl(wf_assign.item_type_code,nvl(p_wfasgn_item_type,'-99'))
58: AND header.header_id = p_line_rec.header_id AND

Line 68: FROM oe_workflow_assignments wf_assign,

64: Order by wf_assign.item_type_code;
65:
66: CURSOR find_NegotiateHdrProcessname(itemkey varchar2) is
67: SELECT wf_assign.process_name
68: FROM oe_workflow_assignments wf_assign,
69: oe_order_headers_all header
70: WHERE header.header_id = to_number(itemkey)
71: and header.order_type_id = wf_assign.order_type_id
72: and sysdate >= wf_assign.start_date_active

Line 79: FROM oe_workflow_assignments wf_assign,

75: and wf_assign.line_type_id IS NULL;
76:
77: CURSOR find_BktNgoHdrProcessname(itemkey varchar2) is
78: SELECT wf_assign.process_name
79: FROM oe_workflow_assignments wf_assign,
80: oe_blanket_headers_all header
81: WHERE header.header_id = to_number(itemkey)
82: and header.order_type_id = wf_assign.order_type_id
83: and sysdate >= wf_assign.start_date_active

Line 90: FROM oe_workflow_assignments wf_assign,

86: and wf_assign.line_type_id IS NULL;
87:
88: CURSOR find_BlanketHdrProcessname(itemkey varchar2) is
89: SELECT wf_assign.process_name
90: FROM oe_workflow_assignments wf_assign,
91: oe_blanket_headers_all blanket
92: WHERE blanket.header_id = to_number(itemkey)
93: and blanket.order_type_id = wf_assign.order_type_id
94: and sysdate >= wf_assign.start_date_active