DBA Data[Home] [Help]

APPS.FA_TRX_APPROVAL_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 119: FROM fa_mc_book_controls

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

Line 138: fa_mc_book_controls mc_bks

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'

Line 211: fa_mc_book_controls mc_bks

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'