APPS.IEX_WF_NEW_DEL_STATUS_PUB dependencies on DUAL

Line 97: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: iex_debug_pub.logmessage('IEX- Before getting item key information....');
96:
97: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;
98:
99: itemkey := 'NEWST'||TO_CHAR(p_delinquency_id)||itemkey;
100:
101: iex_debug_pub.logmessage('IEX- Before getting manager information....');

Line 266: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;

262:
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: SELECT TO_CHAR(IEX_DEL_WF_S.NEXTVAL) INTO itemkey FROM dual;
267:
268: itemkey := 'NEWST'||TO_CHAR(p_delinquency_id)||itemkey;
269:
270: begin