DBA Data[Home] [Help]

APPS.JA_AU_FA_BAL_CHG dependencies on FA_BOOKS

Line 182: from fa_books b1,

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

Line 183: fa_books b2,

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

Line 191: from fa_books bk

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)

Line 450: FA_BOOKS B

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