DBA Data[Home] [Help]

APPS.IEM_ARCH_FLDS_PVT dependencies on DUAL

Line 42: select iem_archived_folders_s1.nextval into l_seq_id from dual;

38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: SAVEPOINT IEM_ARCHFLD_PVT;
42: select iem_archived_folders_s1.nextval into l_seq_id from dual;
43: select nvl(max(FOLDER_SEQ_NUM),0)+1
44: INTO l_fld_id
45: FROM IEM_ARCHIVED_FOLDERS
46: where email_account_id=p_email_account_id