DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on FA_BOOK_CONTROLS

Line 585: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc

581:
582: -- Get all the FA books (corp and tax) that asset belongs to
583: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
584: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
585: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
586: WHERE fb.asset_id = fab.asset_id
587: AND fb.book_type_code = fbc.book_type_code
588: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
589: AND fb.transaction_header_id_out IS NULL