APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on DUAL

Line 167: SELECT SYSDATE INTO l_sysdate FROM DUAL;

163: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:
167: SELECT SYSDATE INTO l_sysdate FROM DUAL;
168:
169: x_sys_date := l_sysdate;
170:
171: IF p_item_number IS NOT NULL THEN

Line 636: FROM DUAL;

632: SUBTYPE artv_rec_type IS OKL_ASSET_RETURNS_PUB.artv_rec_type;
633: -- sequence for item_number
634: CURSOR l_seqnextval_csr IS
635: SELECT OKL_IMR_SEQ.NEXTVAL
636: FROM DUAL;
637:
638: l_Item_rec item_rec_type;
639: x_Item_rec item_rec_type;
640: l_commit VARCHAR2(1);