APPS.FA_MASS_ADD_VALIDATE dependencies on FA_RETIREMENTS

Line 157: (select 1 from fa_retirements faret

153: and (fabk.period_counter_fully_reserved is null or
154: (fabk.period_counter_fully_reserved is not null
155: and fabk.period_counter_life_complete is not null))
156: and not exists
157: (select 1 from fa_retirements faret
158: where faret.asset_id = x_asset_id
159: and faret.book_type_code = x_book_type_code
160: and faret.status in
161: ('PENDING','REINSTATE','PARTIAL')));