DBA Data[Home] [Help]

APPS.FA_DELETION_PVT dependencies on XLA_TRANSACTION_ENTITIES

Line 137: xla_transaction_entities en,

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

Line 167: xla_transaction_entities en,

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

Line 194: from xla_transaction_entities en,

190: end if;
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

Line 223: xla_transaction_entities en,

219: -- of any asset involved in inter-asset transaction
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