115: -- added enabled_clause for reporting books due to BUG# 1486157
116:
117: SELECT count(*)
118: INTO h_mrc_book_count
119: FROM fa_mc_book_controls
120: WHERE book_type_code = X_book
121: AND enabled_flag = 'Y';
122:
123: --IF (X_result) THEN
134:
135: SELECT COUNT(*) INTO h_count_mrc
136: FROM fa_retirements ret,
137: fa_mc_retirements mc_ret,
138: fa_mc_book_controls mc_bks
139: WHERE ret.asset_id = X_asset_id
140: AND ret.book_type_code = X_book
141: AND mc_bks.book_type_code = X_book
142: AND mc_bks.enabled_flag = 'Y'
207:
208: SELECT COUNT(*) INTO h_count_mrc
209: FROM fa_retirements ret,
210: fa_mc_retirements mc_ret,
211: fa_mc_book_controls mc_bks
212: WHERE ret.asset_id = X_asset_id
213: AND ret.book_type_code = l_corp_book
214: AND mc_bks.book_type_code = l_corp_book
215: AND mc_bks.enabled_flag = 'Y'