APPS.FA_TRX_APPROVAL_PKG dependencies on FA_MC_RETIREMENTS

Line 137: fa_mc_retirements mc_ret,

133: END IF;
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

Line 210: fa_mc_retirements mc_ret,

206: END IF;
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