116: END IF;
117:
118: SELECT COUNT(*) INTO h_count_mrc
119: FROM fa_retirements ret,
120: fa_mc_retirements mc_ret,
121: fa_mc_book_controls mc_bks
122: WHERE ret.asset_id = X_asset_id
123: AND ret.book_type_code = X_book
124: AND mc_bks.book_type_code = X_book
187: END IF;
188:
189: SELECT COUNT(*) INTO h_count_mrc
190: FROM fa_retirements ret,
191: fa_mc_retirements mc_ret,
192: fa_mc_book_controls mc_bks
193: WHERE ret.asset_id = X_asset_id
194: AND ret.book_type_code = l_corp_book
195: AND mc_bks.book_type_code = l_corp_book