APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on DUAL

Line 1671: FROM sys.dual;

1667:
1668:
1669: CURSOR c_get_batch IS
1670: SELECT WSH_STOP_BATCH_S.NEXTVAL
1671: FROM sys.dual;
1672:
1673: --/== Workflow Changes
1674: CURSOR c_stop_to_del_cur_wf( p_stop_id IN NUMBER ) IS
1675: SELECT wnd.delivery_id,

Line 3381: FROM dual;

3377:
3378: --added for 4538005
3379: CURSOR get_session_id IS
3380: SELECT mrp_atp_schedule_temp_s.nextVal
3381: FROM dual;
3382:
3383:
3384:
3385: CURSOR get_interface_id IS

Line 3387: FROM sys.dual;

3383:
3384:
3385: CURSOR get_interface_id IS
3386: SELECT mtl_material_transactions_s.nextval
3387: FROM sys.dual;
3388:
3389:
3390: -- FP bug 4166635: cursor to look up trip's freight carrier
3391: -- for frontporting bug 4145337 / 3901066.

Line 5200: FROM sys.dual;

5196: -- bug 5736840
5197:
5198: SELECT mtl_material_transactions_s.nextval
5199: INTO l_transaction_header_id
5200: FROM sys.dual;
5201: --
5202: IF l_debug_on THEN
5203: WSH_DEBUG_SV.logmsg(l_module_name, 'NEW TRANSACTION_HEADER : ' || TO_CHAR ( L_TRANSACTION_HEADER_ID ) );
5204: END IF;