DBA Data[Home] [Help]

APPS.OKL_TRANSACTION_PVT dependencies on DUAL

Line 203: FROM dual;

199: /* Not required as TAPI is generating TRX_NUMBER
200:
201: SELECT okl_txn_number_s.nextval
202: INTO l_id
203: FROM dual;
204:
205: x_tcnv_rec.trx_number := l_id;
206: */
207:

Line 474: -- This procedure checks whether the asset residual value is securitized

470:
471: ------------------------------------------------------------------------------
472: -- PROCEDURE check_contract_securitized
473: --
474: -- This procedure checks whether the asset residual value is securitized
475: -- The value in x_return_status will be
476: -- 'F' - if securitized
477: -- 'S' - if it is not securitized
478: --

Line 588: FROM DUAL

584: CURSOR check_date_csr (p_start_date DATE,
585: p_end_date DATE,
586: p_trx_date DATE) IS
587: SELECT 'Y'
588: FROM DUAL
589: WHERE p_trx_date BETWEEN p_start_date AND p_end_date;
590:
591: l_con_start_date DATE;
592: l_con_end_date DATE;