APPS.FARX_RP dependencies on FA_BOOK_CONTROLS

Line 107: fa_book_controls bc,

103: ad.description,
104: ad.asset_category_id
105: FROM gl_code_combinations gc,
106: fa_distribution_history dh,
107: fa_book_controls bc,
108: fa_books bk,
109: fa_additions ad
110: WHERE ad.asset_type = nvl(mr_rec.asset_type, ad.asset_type)
111: AND ad.asset_number >= nvl(mr_rec.from_asset_number, ad.asset_number)

Line 675: FROM fa_book_controls bc, fa_books bk

671: -- cursor to get all the corporate and tax books the asset belongs to.
672: -- books are ordered in alphabetical order in preview report.
673: CURSOR book_cr IS
674: SELECT bk.book_type_code
675: FROM fa_book_controls bc, fa_books bk
676: WHERE bk.asset_id = a_tbl(a_index).asset_id
677: AND bk.date_ineffective IS NULL
678: AND bk.book_type_code = bc.book_type_code
679: AND bc.book_class IN ('CORPORATE', 'TAX')

Line 684: FROM FA_BOOK_CONTROLS BC,

680: AND nvl(bc.date_ineffective, sysdate+1) > sysdate
681: ORDER BY bk.book_type_code;
682: /*
683: SELECT TH.book_type_code
684: FROM FA_BOOK_CONTROLS BC,
685: FA_TRANSACTION_HEADERS TH
686: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION')
687: AND TH.asset_id = a_tbl(a_index).asset_id
688: AND BC.book_type_code = TH.book_type_code