DBA Data[Home] [Help]

APPS.FA_IMPAIRMENT_DELETE_PVT dependencies on FA_MC_IMPAIRMENTS

Line 52: from fa_mc_impairments imp

48: where transaction_header_id_out is null
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

Line 89: from fa_mc_impairments imp

85: where transaction_header_id_out is null
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