APPS.FA_MASS_ADD_VALIDATE dependencies on FA_RETIREMENTS

Line 155: (select 1 from fa_retirements faret

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