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
1037: FROM OKL_STRM_TYPE_B sty,
1038: OKL_STREAMS stm,
1039: OKL_STRM_ELEMENTS ste,
1040: OKL_PROD_STRM_TYPES_V psty,
1041: OKL_K_HEADERS khr
1042: WHERE stm.khr_id = chr.id
1043: AND khr.id = stm.khr_id
1044: AND stm.say_code = 'CURR'
1045: AND stm.active_yn = 'Y'