966: TRUNC(OTQV.creation_date), -- rmunjulu EDAT Added
967: OTQV.perdiem_amount, -- rmunjulu LOANS_ENHANCEMENT
968: OTQV.REPO_QUOTE_INDICATOR_YN -- Bug 6674730
969: FROM OKL_TRX_QUOTES_V OTQV,
970: OKL_K_HEADERS_FULL_V OKHV
971: WHERE OTQV.id = p_id
972: AND OTQV.khr_id = OKHV.id;
973:
974:
974:
975: -- Cursor to get the contract number
976: CURSOR get_k_num_csr ( p_khr_id IN NUMBER) IS
977: SELECT contract_number
978: FROM OKL_K_HEADERS_FULL_V K
979: WHERE K.id = p_khr_id;
980:
981:
982: -- RMUNJULU -- 12-DEC-02 Bug # 2484327 Changes for Asset level termination