APPS.IEM_OP_STAT_PUB dependencies on DUAL

Line 60: select IEM_OP_CONTROLLER_STATS_S1.nextval into l_con_sequence from dual;

56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: -----------------------Code------------------------
59:
60: select IEM_OP_CONTROLLER_STATS_S1.nextval into l_con_sequence from dual;
61:
62: l_CONTROLLER_ID := l_con_sequence;
63:
64: x_controller_id := l_CONTROLLER_ID;

Line 212: select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;

208: FAILED_REASON = p_tfailed_reason,
209: PROCESSED_MSG_COUNT = p_processed_msg_cnt
210: WHERE OP_THREAD_STATS_ID = l_OP_THREAD_STATS_ID;
211: ELSE
212: select IEM_OP_THREAD_STATS_S1.nextval into l_th_sequence from dual;
213: insert into IEM_OP_THREAD_STATS
214: (
215: OP_THREAD_STATS_ID,
216: THREAD_ID,