DBA Data[Home] [Help]

APPS.FA_DELETION_PVT dependencies on XLA_EVENTS

Line 138: xla_events ev,

134: select count(*)
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

Line 168: xla_events ev,

164: select count(*)
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

Line 195: xla_events ev,

191:
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

Line 224: xla_events ev,

220: select count(*)
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