[Home] [Help]
31: select NVL(to_char(due_date),'NOT FOUND')
32: into l_due_date_string
33: --FROM xdp_oe_order_headers
34: --skilaru 03/27/2001
35: from xdp_order_headers
36: where order_id = p_order_id;
37:
38: IF l_due_date_string = 'NOT FOUND'
39: THEN
72: SELECT due_date
73: INTO l_due_date
74: --FROM xdp_oe_order_headers
75: --skilaru 03/27/2001
76: FROM xdp_order_headers
77: WHERE order_id = p_order_id;
78:
79:
80: IF l_due_date IS NULL THEN