178: sysdate,
179: sysdate ,
180: uid,
181: uid
182: from fa_books b1,
183: fa_books b2,
184: fa_additions a,
185: fa_categories c,
186: fa_methods m
179: sysdate ,
180: uid,
181: uid
182: from fa_books b1,
183: fa_books b2,
184: fa_additions a,
185: fa_categories c,
186: fa_methods m
187: where b1.asset_id = a.asset_id
187: where b1.asset_id = a.asset_id
188: and b1.book_type_code = v_book_type_code
189: and b1.date_effective =
190: (select min(bk.date_effective)
191: from fa_books bk
192: where bk.asset_id = a.asset_id
193: and bk.book_type_code = v_book_type_code
194: and nvl(bk.date_ineffective,sysdate+2) > v_from_date
195: and bk.date_effective <= v_to_date)
446: from FA_DEPRN_PERIODS DP,
447: FA_TRANSACTION_HEADERS TH,
448: FA_RETIREMENTS R,
449: FA_ADDITIONS A,
450: FA_BOOKS B
451: where dp.period_name = (v_period_name)
452:
453: and dp.book_type_code = v_book_type_code
454: and th.book_type_code = v_book_type_code