APPS.EAM_WO_COMP_UTILITY_PVT dependencies on DUAL

Line 201: FROM dual;

197:
198: -- get the asset_status_id from eam_asset_status_history_s sequence
199: SELECT eam_asset_status_history_s.nextval
200: INTO i_asset_status_id
201: FROM dual;
202:
203: -- Enhancement Bug 3852846
204: UPDATE eam_asset_status_history
205: SET enable_flag = 'N'

Line 296: from dual;

292:
293: -- prepare the data to insert into MTL_MATERIAL_TRANSACTIONS_TEMP,
294: -- MTL_SERIAL_NUMBERS_TEMP, and MTL_TRANSACTION_LOTS_TEMP
295: select mtl_material_transactions_s.nextval into i_transaction_header_id
296: from dual;
297:
298:
299: -- get the item info
300: item := wma_derive.getItem(s_rebuild_item_id, s_org_id, s_locator_id);