APPS.FA_TRX_APPROVAL_PKG dependencies on FA_RETIREMENTS

Line 125: FROM fa_retirements faret

121: AND enabled_flag = 'Y';
122:
123: --IF (X_result) THEN
124: SELECT COUNT(*) INTO h_count
125: FROM fa_retirements faret
126: WHERE faret.asset_id = X_asset_id
127: AND faret.book_type_code = X_book
128: AND UPPER(faret.status) in ('PENDING', 'REINSTATE');
129:

Line 136: FROM fa_retirements ret,

132: ,p_log_level_rec => p_log_level_rec);
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

Line 198: FROM fa_retirements faret

194:
195: l_corp_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
196:
197: SELECT COUNT(*) INTO h_count
198: FROM fa_retirements faret
199: WHERE faret.asset_id = X_asset_id
200: AND faret.book_type_code = l_corp_book
201: AND UPPER(faret.status) in ('PENDING');
202:

Line 209: FROM fa_retirements ret,

205: ,p_log_level_rec => p_log_level_rec);
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