DBA Data[Home] [Help]

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_TRX_CONTRACTS

Line 564: FROM okl_trx_contracts a,

560:
561: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
562: SELECT a.date_transaction_occurred,
563: b.date_last_interim_interest_cal
564: FROM okl_trx_contracts a,
565: okl_k_headers b
566: WHERE a.khr_id_new = p_chr_id
567: AND a.tcn_type = 'TRBK'
568: AND a.tsu_code = 'ENTERED'

Line 1746: FROM okl_trx_contracts a,

1742:
1743: CURSOR txn_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1744: SELECT a.date_transaction_occurred,
1745: b.date_last_interim_interest_cal
1746: FROM okl_trx_contracts a,
1747: okl_k_headers b
1748: WHERE a.khr_id_new = p_chr_id
1749: AND a.tcn_type = 'TRBK'
1750: AND a.tsu_code = 'ENTERED'