48: WHERE header_id = p_order_header_id;
49:
50: CURSOR c_get_party_id(p_order_header_id NUMBER) IS
51: SELECT fnd.customer_id
52: FROM fnd_user fnd,
53: oe_order_headers_all oe
54: WHERE oe.header_id = p_order_header_id
55: AND oe.created_by = fnd.user_id;
56:
51: SELECT fnd.customer_id
52: FROM fnd_user fnd,
53: oe_order_headers_all oe
54: WHERE oe.header_id = p_order_header_id
55: AND oe.created_by = fnd.user_id;
56:
57: CURSOR c_get_reject_reason_desc(p_reject_reason_code VARCHAR2) IS
58: SELECT meaning
59: FROM wf_lookups