DBA Data[Home] [Help]

APPS.FA_DELETION_PVT dependencies on FA_TRANSACTION_HEADERS

Line 136: from fa_transaction_headers th,

132: if (fa_cache_pkg.fazcbc_record.book_class = 'TAX') then
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

Line 166: from fa_transaction_headers th,

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

Line 222: from fa_transaction_headers th,

218: -- removing staus check as we need to prevent deletion
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