APPS.WSH_ITM_EXPORT_SCREENING dependencies on DUAL

Line 807: INTO l_tranx_history_rec.document_number FROM DUAL;

803: l_tranx_history_rec.entity_number := l_varchar_delivery_name_tab(k);--DELIVERY NUMBER
804: l_tranx_history_rec.action_type := 'A'; --Sending new Msg
805:
806: SELECT WSH_DOCUMENT_NUMBER_S.NEXTVAL
807: INTO l_tranx_history_rec.document_number FROM DUAL;
808:
809: WSH_TRANSACTIONS_HISTORY_PKG.Create_Update_Txns_History(
810: l_tranx_history_rec,
811: x_txns_id,

Line 835: INTO l_request_control_id_s FROM DUAL;

831: -- This Sub Section Does the Bulk Insert to Request Control Table
832: FOR k IN l_num_delivery_id_tab.FIRST .. l_num_delivery_id_tab.LAST
833: LOOP
834: SELECT WSH_ITM_REQUEST_CONTROL_S.NEXTVAL
835: INTO l_request_control_id_s FROM DUAL;
836: --Bug 6700736 Populating master_organization_id
837: INSERT INTO WSH_ITM_REQUEST_CONTROL(
838: REQUEST_CONTROL_ID,
839: APPLICATION_ID,