99: -- added enabled_clause for reporting books due to BUG# 1486157
100:
101: SELECT count(*)
102: INTO h_mrc_book_count
103: FROM fa_mc_book_controls
104: WHERE book_type_code = X_book
105: AND enabled_flag = 'Y';
106:
107: --IF (X_result) THEN
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
125: AND mc_bks.enabled_flag = 'Y'
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
196: AND mc_bks.enabled_flag = 'Y'