DBA Data[Home] [Help]

APPS.FA_TRX_APPROVAL_PKG dependencies on FA_MC_BOOK_CONTROLS

Line 103: FROM fa_mc_book_controls

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

Line 121: fa_mc_book_controls mc_bks

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'

Line 192: fa_mc_book_controls mc_bks

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'