APPS.OKL_AM_ASSET_RETURN_PVT dependencies on OKL_ASSET_RETURNS_B

Line 1602: OKL_ASSET_RETURNS_B OAR

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:
1606: --SECHAWLA 22-JAN-03 Bug # 2762419 : new declarations

Line 1659: FROM okl_asset_returns_b

1655:
1656: -- SECHAWLA 29-OCT-04 3924244 : new declaraions
1657: CURSOR l_assetreturn_csr(cp_id IN NUMBER) IS
1658: SELECT imr_id, new_item_number
1659: FROM okl_asset_returns_b
1660: WHERE id = cp_id;
1661:
1662: l_wf_imr_id NUMBER;
1663: l_wf_new_item_number VARCHAR2(40);