DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_ITF_IMPAIRMENTS

Line 53: , fa_mc_itf_impairments itf

49: and book_type_code = p_book_type_code
50: and set_of_books_id = p_set_of_books_id
51: and asset_id in (select itf.asset_id
52: from fa_mc_impairments imp
53: , fa_mc_itf_impairments itf
54: where itf.impairment_id = imp.impairment_id
55: and itf.book_type_code = p_book_type_code
56: and itf.worker_id = p_worker_id
57: and imp.request_id = p_request_id

Line 90: , fa_mc_itf_impairments itf

86: and book_type_code = p_book_type_code
87: and set_of_books_id = p_set_of_books_id
88: and asset_id in (select itf.asset_id
89: from fa_mc_impairments imp
90: , fa_mc_itf_impairments itf
91: where itf.impairment_id = imp.impairment_id
92: and itf.book_type_code = p_book_type_code
93: and itf.worker_id = p_worker_id
94: and itf.set_of_books_id = p_set_of_books_id

Line 185: delete from fa_mc_itf_impairments

181: and set_of_books_id = p_set_of_books_id ;
182: end if;
183:
184: FORALL i in 1..t_thid.count
185: delete from fa_mc_itf_impairments
186: where asset_id = t_asset_id(i)
187: and book_type_code = p_book_type_code
188: and worker_id = p_worker_id
189: and period_counter = p_period_rec.period_counter