DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on OKL_ASSET_RETURNS_B

Line 99: FROM okl_asset_returns_b KAR

95: --Cursor to check if the asset is a released asset
96: -- 'N' to indicate it is not a new asset
97: CURSOR chk_rel_ass_csr (p_asset_number VARCHAR2) IS
98: SELECT 'N' new_asset
99: FROM okl_asset_returns_b KAR
100: WHERE KAR.kle_id IN (SELECT KLE.cle_id
101: FROM okl_txl_assets_b TXL
102: ,okl_txd_assets_b TXD
103: ,okc_k_lines_b KLE