APPS.CSI_UTL_PKG dependencies on DUAL

Line 2332: FROM sys.dual

2328: /* check if this item is at the leaf node */
2329: BEGIN
2330: SELECT 'Y'
2331: INTO l_leaf_node
2332: FROM sys.dual
2333: WHERE exists (SELECT 'X' FROM oe_order_lines_all
2334: WHERE header_id = p_order_line_rec.header_id
2335: AND link_to_line_id = p_order_line_rec.order_line_id);
2336:

Line 5497: FROM dual;

5493: debug('l_end ='||l_end );
5494:
5495: SELECT mod(l_line_dtl_tbl(1).quantity,p_ratio)
5496: INTO l_mod_value
5497: FROM dual;
5498:
5499: debug('l_line_dtl_tbl(1).quantity ='||l_line_dtl_tbl(1).quantity);
5500:
5501: debug('l_mod_value ='||l_mod_value);

Line 7471: SELECT 1 INTO l_lot_ctrl_code FROM dual WHERE (--condition

7467: -- if not lot controlled
7468: IF p_transaction_id IS NOT NULL THEN
7469: BEGIN
7470:
7471: SELECT 1 INTO l_lot_ctrl_code FROM dual WHERE (--condition
7472: EXISTS
7473: (SELECT * FROM
7474: mtl_material_transactions mmt,mtl_unit_transactions mut
7475: where mut.transaction_id(+) = mmt.transaction_id

Line 7507: SELECT 2 INTO l_lot_ctrl_code FROM dual WHERE EXISTS

7503:
7504: --full lot controlled
7505: BEGIN
7506:
7507: SELECT 2 INTO l_lot_ctrl_code FROM dual WHERE EXISTS
7508: (--condition
7509:
7510: SELECT * FROM
7511: mtl_material_transactions mmt, mtl_transaction_lot_numbers