APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on DUAL

Line 1228: FROM sys.dual;

1224:
1225:
1226: CURSOR c_get_batch IS
1227: SELECT WSH_STOP_BATCH_S.NEXTVAL
1228: FROM sys.dual;
1229:
1230: --/== Workflow Changes
1231: CURSOR c_stop_to_del_cur_wf( p_stop_id IN NUMBER ) IS
1232: SELECT wnd.delivery_id,

Line 2771: FROM dual;

2767:
2768: --added for 4538005
2769: CURSOR get_session_id IS
2770: SELECT mrp_atp_schedule_temp_s.nextVal
2771: FROM dual;
2772:
2773:
2774:
2775: CURSOR get_interface_id IS

Line 2777: FROM sys.dual;

2773:
2774:
2775: CURSOR get_interface_id IS
2776: SELECT mtl_material_transactions_s.nextval
2777: FROM sys.dual;
2778:
2779:
2780: -- FP bug 4166635: cursor to look up trip's freight carrier
2781: -- for frontporting bug 4145337 / 3901066.

Line 4222: FROM sys.dual;

4218: -- bug 5736840
4219:
4220: SELECT mtl_material_transactions_s.nextval
4221: INTO l_transaction_header_id
4222: FROM sys.dual;
4223: --
4224: IF l_debug_on THEN
4225: WSH_DEBUG_SV.logmsg(l_module_name, 'NEW TRANSACTION_HEADER : ' || TO_CHAR ( L_TRANSACTION_HEADER_ID ) );
4226: END IF;