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 499: -- This procedure checks whether the asset residual value is securitized

495:
496: ------------------------------------------------------------------------------
497: -- PROCEDURE check_contract_securitized
498: --
499: -- This procedure checks whether the asset residual value is securitized
500: -- The value in x_return_status will be
501: -- 'F' - if securitized
502: -- 'S' - if it is not securitized
503: --

Line 613: FROM DUAL

609: CURSOR check_date_csr (p_start_date DATE,
610: p_end_date DATE,
611: p_trx_date DATE) IS
612: SELECT 'Y'
613: FROM DUAL
614: WHERE p_trx_date BETWEEN p_start_date AND p_end_date;
615:
616: l_con_start_date DATE;
617: l_con_end_date DATE;