DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKL_TRX_QUOTES_B

Line 1529: FROM OKL_TRX_QUOTES_B Q

1525: -- Cursor to get the quote details of a quote that is already accepted for
1526: -- the same contract for which this quote is being generated.
1527: CURSOR get_accepted_qte_details_csr( p_khr_id IN NUMBER) IS
1528: SELECT Q.quote_number, Q.qtp_code
1529: FROM OKL_TRX_QUOTES_B Q
1530: WHERE Q.khr_id = p_khr_id
1531: AND Q.accepted_yn = 'Y';
1532:
1533: -- This cursor is used to check if a particular asset belongs to a particular contract.

Line 4080: FROM OKL_TRX_QUOTES_B

4076: l_repo_yn VARCHAR2(1);
4077:
4078: CURSOR check_repo_csr(p_quote_id IN NUMBER) IS
4079: SELECT NVL(repo_quote_indicator_yn,'N')
4080: FROM OKL_TRX_QUOTES_B
4081: WHERE id = p_quote_id;
4082:
4083: BEGIN
4084: -- Check whether the quote is for Repossession