DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_TRX_CONTRACTS

Line 554: FROM okl_trx_contracts a,

550:
551: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
552: SELECT a.date_transaction_occurred,
553: b.date_last_interim_interest_cal
554: FROM okl_trx_contracts a,
555: okl_k_headers b
556: WHERE a.khr_id_new = p_chr_id
557: AND a.tcn_type = 'TRBK'
558: AND a.tsu_code = 'ENTERED'

Line 1736: FROM okl_trx_contracts a,

1732:
1733: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1734: SELECT a.date_transaction_occurred,
1735: b.date_last_interim_interest_cal
1736: FROM okl_trx_contracts a,
1737: okl_k_headers b
1738: WHERE a.khr_id_new = p_chr_id
1739: AND a.tcn_type = 'TRBK'
1740: AND a.tsu_code = 'ENTERED'