APPS.EAM_OP_COMP dependencies on DUAL

Line 323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;

319: APP_EXCEPTION.Raise_Exception;
320: END IF;
321: close C;
322:
323: select eam_op_completion_txns_s.nextval into l_transaction_id from dual;
324:
325: -- -insert into TABLE eam_op_completion_txns
326: INSERT INTO EAM_OP_COMPLETION_TXNS(
327: TRANSACTION_ID,

Line 447: select eam_asset_status_history_s.nextval into l_status_id from dual;

443: -- SHUTDOWN History
444: if (p_shutdown_start_date is not null) or
445: (p_shutdown_end_date is not null) then
446:
447: select eam_asset_status_history_s.nextval into l_status_id from dual;
448:
449: INSERT INTO EAM_ASSET_STATUS_HISTORY(
450: ASSET_STATUS_ID,
451: ASSET_GROUP_ID,

Line 546: FROM DUAL;

542: won.prior_operation =p_operation_seq_num;
543:
544: SELECT EAM_WORKFLOW_EVENT_S.NEXTVAL
545: INTO l_wf_event_seq
546: FROM DUAL;
547:
548: l_parameter_list := wf_parameter_list_t();
549:
550: l_event_key := TO_CHAR(l_wf_event_seq);