APPS.WSH_ITM_EXPORT_SCREENING dependencies on DUAL

Line 794: INTO l_tranx_history_rec.document_number FROM DUAL;

790: l_tranx_history_rec.entity_number := l_varchar_delivery_name_tab(k);--DELIVERY NUMBER
791: l_tranx_history_rec.action_type := 'A'; --Sending new Msg
792:
793: SELECT WSH_DOCUMENT_NUMBER_S.NEXTVAL
794: INTO l_tranx_history_rec.document_number FROM DUAL;
795:
796: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(
797: l_tranx_history_rec,
798: x_txns_id,

Line 822: INTO l_request_control_id_s FROM DUAL;

818: -- This Sub Section Does the Bulk Insert to Request Control Table
819: FOR k IN l_num_delivery_id_tab.FIRST .. l_num_delivery_id_tab.LAST
820: LOOP
821: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
822: INTO l_request_control_id_s FROM DUAL;
823: --Bug 6700736 Populating master_organization_id
824: INSERT INTO WSH_ITM_REQUEST_CONTROL(
825: REQUEST_CONTROL_ID,
826: APPLICATION_ID,