DBA Data[Home] [Help]

APPS.FA_DELETION_PVT dependencies on FA_BOOK_CONTROLS

Line 139: fa_book_controls bc

135: into l_count
136: from fa_transaction_headers th,
137: xla_transaction_entities en,
138: xla_events ev,
139: fa_book_controls bc
140: where bc.book_type_code = px_asset_hdr_rec.book_type_code
141: and th.book_type_code = bc.distribution_source_book
142: and th.asset_id = px_asset_hdr_rec.asset_id
143: and en.application_id = 140

Line 169: fa_book_controls bc

165: into l_count
166: from fa_transaction_headers th,
167: xla_transaction_entities en,
168: xla_events ev,
169: fa_book_controls bc
170: where bc.book_type_code = px_asset_hdr_rec.book_type_code
171: and th.book_type_code = px_asset_hdr_rec.book_type_code
172: and th.asset_id = px_asset_hdr_rec.asset_id
173: and en.application_id = 140

Line 196: fa_book_controls bc

192: select count(*)
193: into l_count
194: from xla_transaction_entities en,
195: xla_events ev,
196: fa_book_controls bc
197: where bc.distribution_source_book = px_asset_hdr_rec.book_type_code
198: and en.application_id = 140
199: and en.ledger_id = bc.set_of_books_id
200: and en.entity_code = 'DEPRECIATION'

Line 225: fa_book_controls bc

221: into l_count
222: from fa_transaction_headers th,
223: xla_transaction_entities en,
224: xla_events ev,
225: fa_book_controls bc
226: where bc.distribution_source_book = px_asset_hdr_rec.book_type_code
227: and th.book_type_code = bc.book_type_code
228: and th.asset_id = px_asset_hdr_rec.asset_id
229: and en.application_id = 140