DBA Data[Home] [Help]

APPS.FA_TRX_APPROVAL_PKG dependencies on FA_MC_RETIREMENTS

Line 120: fa_mc_retirements mc_ret,

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

Line 191: fa_mc_retirements mc_ret,

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