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 6047: FROM DUAL

6043: IF (l_ret = 'Y') THEN
6044: BEGIN
6045: SELECT 'Y'
6046: INTO multiple_lpns
6047: FROM DUAL
6048: WHERE EXISTS( SELECT mmtt.transaction_temp_id
6049: FROM mtl_material_transactions_temp mmtt, wsh_delivery_details wdd, wsh_delivery_assignments_v wda
6050: WHERE NVL(mmtt.cartonization_id, -1) <> p_lpn_id
6051: AND mmtt.move_order_line_id = wdd.move_order_line_id

Line 6135: FROM DUAL

6131: END;
6132:
6133: SELECT 'Y'
6134: INTO l_ret
6135: FROM DUAL
6136: WHERE EXISTS( SELECT transaction_temp_id
6137: FROM mtl_material_transactions_temp
6138: WHERE transaction_temp_id = p_transaction_temp_id
6139: AND transaction_type_id IN (inv_globals.g_type_xfer_order_wip_issue, inv_globals.g_type_xfer_order_repl_subxfr));