APPS.OE_ORDER_PURGE_PVT dependencies on DUAL

Line 223: FROM DUAL;

219: INTO l_ordered_date_low,
220: l_ordered_date_high,
221: l_creation_date_low,
222: l_creation_date_high
223: FROM DUAL;
224:
225:
226: -- SQL literal changes
227: IF nvl(p_order_number_low,0) <> 0 AND

Line 721: FROM DUAL;

717: l_creation_date_low,
718: l_creation_date_high,
719: l_quote_date_low,
720: l_quote_date_high
721: FROM DUAL;
722:
723:
724: --Quote Number Range
725:

Line 1208: FROM DUAL;

1204: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Insert_Purge_Set : '||p_purge_set_name,1);
1205:
1206: SELECT OE_PURGE_SETS_S.NEXTVAL
1207: INTO l_purge_set_id
1208: FROM DUAL;
1209:
1210: l_orders_per_commit := FND_PROFILE.VALUE('OM_ORDERS_PURGE_PER_COMMIT');
1211:
1212: INSERT INTO OE_PURGE_SETS

Line 2776: FROM DUAL

2772: CURSOR c_price_adj_assocs(p_price_adjustment_id NUMBER) IS
2773: SELECT price_adj_assoc_id
2774: FROM OE_PRICE_ADJ_ASSOCS OPAA
2775: WHERE opaa.rltd_price_adj_id IN (SELECT TO_NUMBER (p_price_adjustment_id)
2776: FROM DUAL
2777: UNION ALL
2778: SELECT opaa1.rltd_price_adj_id
2779: FROM oe_price_adj_assocs opaa1
2780: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);

Line 2915: FROM DUAL

2911: SELECT price_adj_assoc_id
2912: FROM OE_PRICE_ADJ_ASSOCS OPAA
2913: WHERE opaa.rltd_price_adj_id IN (
2914: SELECT p_price_adjustment_id
2915: FROM DUAL
2916: UNION ALL
2917: SELECT opaa1.rltd_price_adj_id
2918: FROM oe_price_adj_assocs opaa1
2919: WHERE opaa1.price_adjustment_id = p_price_adjustment_id);