DBA Data[Home] [Help]

APPS.OKL_AM_CNTRCT_LN_TRMNT_PVT dependencies on FA_BOOKS

Line 5751: -- Get all the FA books (corp and tax) that asset belongs to

5747: px_tcnv_rec IN OUT NOCOPY tcnv_rec_type,
5748: x_return_status OUT NOCOPY VARCHAR2
5749: )
5750: IS
5751: -- Get all the FA books (corp and tax) that asset belongs to
5752: CURSOR l_fabooks_csr (
5753: cp_asset_number IN VARCHAR2,
5754: cp_sysdate IN DATE
5755: )

Line 5760: FROM fa_books fb,

5756: IS
5757: SELECT fb.book_type_code,
5758: fb.asset_id,
5759: fb.contract_id
5760: FROM fa_books fb,
5761: fa_additions_b fab,
5762: fa_book_controls fbc
5763: WHERE fb.asset_id = fab.asset_id
5764: AND fb.book_type_code = fbc.book_type_code