DBA Data[Home] [Help]

APPS.FA_MASSCHG_PKG dependencies on FA_BOOK_CONTROLS

Line 606: from fa_book_controls bc,

602: where bk.asset_id = l_asset_id(l_loop_count) and
603: bk.date_ineffective is null and
604: bk.book_type_code in
605: (select bc.book_type_code
606: from fa_book_controls bc,
607: fa_methods me
608: where bc.date_ineffective is null
609: and bc.distribution_source_book = l_book_type_code
610: and bc.book_class <> 'BUDGET'

Line 703: from fa_book_controls bc,

699: if (fa_cache_pkg.fazcbc_record.book_class = 'CORPORATE') then
700:
701: select count(*)
702: into l_count
703: from fa_book_controls bc,
704: fa_books bk,
705: fa_methods me
706: where bk.book_type_code = bc.book_type_code
707: and bk.asset_id = l_asset_id(l_loop_count)

Line 732: from fa_book_controls bc,

728: -- first check isn't need (asset in corp book)
729:
730: select count(*)
731: into l_count
732: from fa_book_controls bc,
733: fa_books bk,
734: fa_methods me
735: where bk.book_type_code = bc.distribution_source_book
736: and bk.asset_id = l_asset_id(l_loop_count)

Line 994: from fa_book_controls bc,

990: where bk.asset_id = l_asset_id(l_loop_count)
991: and bk.date_ineffective is null
992: and bk.book_type_code in
993: (select bc.book_type_code
994: from fa_book_controls bc,
995: fa_methods me
996: where bc.distribution_source_book = l_book_type_code
997: and bc.book_class = 'TAX'
998: and bc.date_ineffective is null