DBA Data[Home] [Help]

APPS.XNP_DEF_JEOPARDY_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

	-- Select Due Date from xdp_oe_order_headers
	select NVL(to_char(due_date),'NOT FOUND')
	into l_due_date_string
        --FROM xdp_oe_order_headers
        --skilaru 03/27/2001
	from xdp_order_headers
	where order_id = p_order_id;
Line: 72

	SELECT due_date
    INTO l_due_date
    --FROM xdp_oe_order_headers
    --skilaru 03/27/2001
    FROM xdp_order_headers
    WHERE order_id = p_order_id;