DBA Data[Home] [Help]

APPS.XDP_OE_ORDER dependencies on DUAL

Line 154: FROM DUAL

150: BEGIN
151: -- IF P_Version IS NULL THEN
152: BEGIN
153: SELECT 'Y' INTO lv_exists_flag
154: FROM DUAL
155: WHERE EXISTS
156: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
157: WHERE ORDER_NUMBER =
158: UPPER(P_Order_Number));

Line 167: FROM DUAL

163: END;
164: /* ELSE
165: BEGIN
166: SELECT 'Y' INTO lv_exists_flag
167: FROM DUAL
168: WHERE EXISTS
169: ( SELECT 'x' FROM XDP_OE_ORDER_HEADERS
170: WHERE ORDER_NUMBER =
171: UPPER( P_Order_Number) AND