DBA Data[Home] [Help]

APPS.FA_MASSCHG_PKG dependencies on FA_BOOK_CONTROLS

Line 521: from fa_book_controls bc,

517: where bk.asset_id = l_asset_id(l_loop_count) and
518: bk.date_ineffective is null and
519: bk.book_type_code in
520: (select bc.book_type_code
521: from fa_book_controls bc,
522: fa_methods me
523: where bc.date_ineffective is null
524: and bc.distribution_source_book = l_book_type_code
525: and bc.book_class <> 'BUDGET'

Line 621: from fa_book_controls bc,

617: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
618:
619: select count(*)
620: into l_count
621: from fa_book_controls bc,
622: fa_books bk,
623: fa_methods me
624: where bk.book_type_code = bc.book_type_code
625: and bk.asset_id = l_asset_id(l_loop_count)

Line 650: from fa_book_controls bc,

646: -- first check isn't need (asset in corp book)
647:
648: select count(*)
649: into l_count
650: from fa_book_controls bc,
651: fa_books bk,
652: fa_methods me
653: where bk.book_type_code = bc.distribution_source_book
654: and bk.asset_id = l_asset_id(l_loop_count)

Line 912: from fa_book_controls bc,

908: where bk.asset_id = l_asset_id(l_loop_count)
909: and bk.date_ineffective is null
910: and bk.book_type_code in
911: (select bc.book_type_code
912: from fa_book_controls bc,
913: fa_methods me
914: where bc.distribution_source_book = l_book_type_code
915: and bc.book_class = 'TAX'
916: and bc.date_ineffective is null