APPS.IGI_IMP_IAC_EXCEP_INER_PKG dependencies on FA_DEPRN_SUMMARY

Line 162: fa_deprn_summary b

158: b.deprn_reserve,
159: b.ytd_deprn
160: FROM fa_books a,
161: fa_additions ad,
162: fa_deprn_summary b
163: WHERE a.book_type_code = p_book
164: AND ad.asset_id = a.asset_id
165: AND a.date_ineffective IS NULL
166: AND b.asset_id = a.asset_id

Line 169: FROM fa_deprn_summary

165: AND a.date_ineffective IS NULL
166: AND b.asset_id = a.asset_id
167: AND b.book_type_code = a.book_type_code
168: AND b.period_counter = (SELECT MAX(period_counter)
169: FROM fa_deprn_summary
170: WHERE book_type_code = a.book_type_code
171: AND asset_id = a.asset_id);
172:
173: Cursor C_Mhca_Book_Info(p_book in varchar2, p_asset_id in number) Is

Line 198: fa_deprn_summary b,

194: b.period_counter,
195: b.deprn_reserve,
196: b.ytd_deprn
197: from fa_books a ,
198: fa_deprn_summary b,
199: fa_additions ad
200: Where a.book_type_code = p_book
201: and a.asset_id = p_asset_id
202: and ad.asset_id = a.asset_id

Line 206: from fa_deprn_summary

202: and ad.asset_id = a.asset_id
203: and a.book_type_code = b.book_type_code
204: and b.asset_id = a.asset_id
205: and b.period_counter = (select max(period_counter)
206: from fa_deprn_summary
207: where book_type_code =p_book
208: and asset_id =p_asset_id)
209: and a.date_ineffective is null;
210: