DBA Data[Home] [Help]

APPS.XDPCORE_ORDER dependencies on DUAL

Line 199: FROM dual

195:
196: BEGIN
197: SELECT 'Y'
198: INTO l_Continue
199: FROM dual
200: WHERE EXISTS (SELECT LINE_ITEM_ID
201: FROM XDP_ORDER_LINE_ITEMS
202: WHERE ORDER_ID = l_OrderID
203: AND STATUS_CODE = 'READY'

Line 279: FROM dual

275:
276: BEGIN
277: SELECT 1
278: INTO l_BundleCount
279: FROM dual
280: WHERE EXISTS(SELECT BUNDLE_ID
281: FROM XDP_ORDER_LINE_ITEMS
282: WHERE ORDER_ID = l_OrderID
283: AND PROVISIONING_REQUIRED_FLAG = 'Y'