APPS.XDP_ORDER_SYNC dependencies on DUAL

Line 183: FROM dual

179:
180: -- See if any line has error status
181: BEGIN
182: SELECT 'N' INTO l_done
183: FROM dual
184: WHERE EXISTS( SELECT 'x' FROM
185: xdp_order_line_items
186: WHERE order_id = p_order_id AND
187: status_code = 'ERROR');

Line 274: SELECT 'N' INTO lv_done FROM dual

270: END LOOP;
271:
272: -- Check if any workitem was in error status
273: BEGIN
274: SELECT 'N' INTO lv_done FROM dual
275: WHERE EXISTS( SELECT 'x' FROM
276: XDP_FULFILL_WORKLIST
277: WHERE line_item_id = p_lineItem_id AND
278: status_code = 'ERROR');