APPS.OKL_AM_CUSTOM_RMK_ASSET_PVT dependencies on DUAL

Line 169: SELECT SYSDATE INTO l_sysdate FROM DUAL;

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

Line 640: FROM DUAL;

636: SUBTYPE artv_rec_type IS OKL_ASSET_RETURNS_PUB.artv_rec_type;
637: -- sequence for item_number
638: CURSOR l_seqnextval_csr IS
639: SELECT OKL_IMR_SEQ.NEXTVAL
640: FROM DUAL;
641:
642: l_Item_rec item_rec_type;
643: x_Item_rec item_rec_type;
644: l_commit VARCHAR2(1);