DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_ITF_IMPAIRMENTS

Line 69: , fa_itf_impairments itf

65: where transaction_header_id_out is null
66: and book_type_code = p_book_type_code
67: and asset_id in (select itf.asset_id
68: from fa_impairments imp
69: , fa_itf_impairments itf
70: where itf.impairment_id = imp.impairment_id
71: and itf.book_type_code = p_book_type_code
72: and itf.worker_id = p_worker_id
73: and imp.request_id = p_request_id

Line 199: , fa_itf_impairments itf

195: where transaction_header_id_out is null
196: and book_type_code = p_book_type_code
197: and asset_id in (select itf.asset_id
198: from fa_impairments imp
199: , fa_itf_impairments itf
200: where itf.impairment_id = imp.impairment_id
201: and itf.book_type_code = p_book_type_code
202: and itf.worker_id = p_worker_id
203: and imp.request_id = p_request_id

Line 289: delete from fa_itf_impairments

285: where transaction_header_id = t_thid(i);
286: end if;
287:
288: FORALL i in 1..t_thid.count
289: delete from fa_itf_impairments
290: where asset_id = t_asset_id(i)
291: and book_type_code = p_book_type_code
292: and worker_id = p_worker_id
293: and period_counter = p_period_rec.period_counter;