APPS.FA_TRX_APPROVAL_PKG dependencies on FA_RETIREMENTS

Line 109: FROM fa_retirements faret

105: AND enabled_flag = 'Y';
106:
107: --IF (X_result) THEN
108: SELECT COUNT(*) INTO h_count
109: FROM fa_retirements faret
110: WHERE faret.asset_id = X_asset_id
111: AND faret.book_type_code = X_book
112: AND UPPER(faret.status) in ('PENDING', 'REINSTATE');
113:

Line 119: FROM fa_retirements ret,

115: FA_DEBUG_PKG.ADD ('FA:faxcti','h_count in faxcti = ',h_count, p_log_level_rec => p_log_level_rec);
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

Line 179: FROM fa_retirements faret

175:
176: l_corp_book := fa_cache_pkg.fazcbc_record.distribution_source_book;
177:
178: SELECT COUNT(*) INTO h_count
179: FROM fa_retirements faret
180: WHERE faret.asset_id = X_asset_id
181: AND faret.book_type_code = l_corp_book
182: AND UPPER(faret.status) in ('PENDING');
183:

Line 190: FROM fa_retirements ret,

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