DBA Data[Home] [Help]

APPS.OKL_AM_LEASE_TRMNT_PVT dependencies on FA_ADDITIONS_B

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

697:
698: -- Get all the FA books (corp and tax) that asset belongs to
699: CURSOR l_fabooks_csr(cp_asset_number IN VARCHAR2, cp_sysdate IN DATE) IS
700: SELECT fb.book_type_code, fb.asset_id, fb.contract_id --SECHAWLA 02-Jan-08 6720667 : Added contract_id
701: FROM fa_books fb, fa_additions_b fab, fa_book_controls fbc
702: WHERE fb.asset_id = fab.asset_id
703: AND fb.book_type_code = fbc.book_type_code
704: AND nvl(fbc.date_ineffective,cp_sysdate+1) > cp_sysdate
705: AND fb.transaction_header_id_out IS NULL