DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_ASSET_PVT dependencies on OKX_AST_DPRTNS_V

Line 711: from OKX_AST_DPRTNS_V

707:
708: Cursor Deprn_csr (p_asset_id IN VARCHAR2,
709: p_Book_Type_Code IN VARCHAR2) IS
710: select sum(deprn_amount)
711: from OKX_AST_DPRTNS_V
712: where Asset_id = to_number(p_asset_id)
713: and book_type_code = p_book_type_code
714: and status = 'A'
715: and nvl(start_date_active,sysdate) <= sysdate