DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_CONTRACT_BALANCES

Line 873: from okl_contract_balances cbl

869: --get asset termination value between range dates
870: Cursor c_asset_term_val_csr(cp_khr_id IN NUMBER, cp_from_date IN DATE, cp_to_date IN DATE) IS
871: select trunc(cbl.termination_date) term_date
872: , nvl(sum(cbl.termination_value_amt), 0) term_value
873: from okl_contract_balances cbl
874: where cbl.khr_id = cp_khr_id
875: and cbl.termination_date between cp_from_date and cp_to_date
876: group by trunc(cbl.termination_date);
877: