APPS.FARX_RP dependencies on FA_BOOK_CONTROLS

Line 105: fa_book_controls bc,

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

Line 652: FROM fa_book_controls bc, fa_books bk

648: -- cursor to get all the corporate and tax books the asset belongs to.
649: -- books are ordered in alphabetical order in preview report.
650: CURSOR book_cr IS
651: SELECT bk.book_type_code
652: FROM fa_book_controls bc, fa_books bk
653: WHERE bk.asset_id = a_tbl(a_index).asset_id
654: AND bk.date_ineffective IS NULL
655: AND bk.book_type_code = bc.book_type_code
656: AND bc.book_class IN ('CORPORATE', 'TAX')

Line 661: FROM FA_BOOK_CONTROLS BC,

657: AND nvl(bc.date_ineffective, sysdate+1) > sysdate
658: ORDER BY bk.book_type_code;
659: /*
660: SELECT TH.book_type_code
661: FROM FA_BOOK_CONTROLS BC,
662: FA_TRANSACTION_HEADERS TH
663: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION')
664: AND TH.asset_id = a_tbl(a_index).asset_id
665: AND BC.book_type_code = TH.book_type_code