APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKL_TRX_QUOTES_B

Line 682: FROM okl_trx_quotes_b qtb

678:
679: --Bug# 3925453: pagarg +++ T and A +++++++ Start ++++++++++
680: CURSOR l_qte_type_csr(p_quote_id NUMBER) IS
681: SELECT qtb.qtp_code
682: FROM okl_trx_quotes_b qtb
683: WHERE qtb.id = p_quote_id;
684:
685: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
686: --Bug# 3925453: pagarg +++ T and A +++++++ End ++++++++++

Line 685: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;

681: SELECT qtb.qtp_code
682: FROM okl_trx_quotes_b qtb
683: WHERE qtb.id = p_quote_id;
684:
685: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
686: --Bug# 3925453: pagarg +++ T and A +++++++ End ++++++++++
687:
688: -- RRAVIKIR Legal Entity Changes
689: CURSOR fetch_legal_entity(p_khr_id NUMBER) IS

Line 1601: FROM OKL_TRX_QUOTES_B OTQB ,

1597:
1598: -- This cursor is used to get an accepted repurchase quote for an asset
1599: CURSOR l_repurchasetasset_csr(p_art_id NUMBER) IS
1600: SELECT OTQB.ID QUOTE_ID , OTQB.ACCEPTED_YN ACCEPTED_YN
1601: FROM OKL_TRX_QUOTES_B OTQB ,
1602: OKL_ASSET_RETURNS_B OAR
1603: WHERE OTQB.ART_ID = OAR.ID
1604: AND OTQB.ART_ID = p_art_id;
1605: