APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKL_TRX_QUOTES_V

Line 1827: FROM OKL_TRX_QUOTES_V

1823:
1824: -- Cursor to get accepted quotes for contract
1825: CURSOR k_accepted_quote_csr IS
1826: SELECT 'x'
1827: FROM OKL_TRX_QUOTES_V
1828: WHERE khr_id = p_contract_id
1829: AND qst_code = 'ACCEPTED'
1830: AND (qtp_code LIKE 'TER%' OR qtp_code LIKE 'RES%');
1831:

Line 2773: FROM OKL_TRX_QUOTES_V QTE

2769: -- Get the quote details
2770: CURSOR l_qte_csr ( p_qte_id IN NUMBER) IS
2771: SELECT QTE.id,
2772: QTE.partial_yn
2773: FROM OKL_TRX_QUOTES_V QTE
2774: WHERE QTE.id = p_qte_id;
2775:
2776:
2777: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 3518: from okl_trx_quotes_v

3514:
3515: -- get accepted date for the termination quote
3516: cursor c_term_quote(c_quote_id number) is
3517: select quote_number
3518: from okl_trx_quotes_v
3519: where id = c_quote_id
3520: AND accepted_yn ='Y';
3521:
3522: -- get contract_end_date