APPS.WMS_PARAMETER_PVT dependencies on DUAL

Line 5036: FROM DUAL

5032: l_return_value VARCHAR2(1);
5033: BEGIN
5034: SELECT 'Y'
5035: INTO l_return_value
5036: FROM DUAL
5037: WHERE EXISTS( SELECT 'Y'
5038: FROM mtl_onhand_quantities_detail
5039: WHERE organization_id = p_organization_id
5040: AND inventory_item_id = p_inventory_item_id

Line 6033: FROM DUAL

6029: IF (l_ret = 'Y') THEN
6030: BEGIN
6031: SELECT 'Y'
6032: INTO multiple_lpns
6033: FROM DUAL
6034: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6035: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6036: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6037: AND mmtt.move_order_line_id = wdd.move_order_line_id

Line 6121: FROM DUAL

6117: END;
6118:
6119: SELECT 'Y'
6120: INTO l_ret
6121: FROM DUAL
6122: WHERE EXISTS( SELECT transaction_temp_id
6123: FROM mtl_material_transactions_temp
6124: WHERE transaction_temp_id = p_transaction_temp_id
6125: AND transaction_type_id IN (inv_globals.g_type_xfer_order_wip_issue, inv_globals.g_type_xfer_order_repl_subxfr));