1845:
1846: -- Cursor to get accepted quotes for contract
1847: CURSOR k_accepted_quote_csr IS
1848: SELECT 'x'
1849: FROM OKL_TRX_QUOTES_V
1850: WHERE khr_id = p_contract_id
1851: AND qst_code = 'ACCEPTED'
1852: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
1853:
2791: -- Get the quote details
2792: CURSOR l_qte_csr ( p_qte_id IN NUMBER) IS
2793: SELECT QTE.id,
2794: QTE.partial_yn
2795: FROM OKL_TRX_QUOTES_V QTE
2796: WHERE QTE.id = p_qte_id;
2797:
2798:
2799: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3536:
3537: -- get accepted date for the termination quote
3538: cursor c_term_quote(c_quote_id number) is
3539: select quote_number
3540: from okl_trx_quotes_v
3541: where id = c_quote_id
3542: AND accepted_yn ='Y';
3543:
3544: -- get contract_end_date