APPS.FA_CUA_GAIN_LOSS_EXT_PKG dependencies on FA_BOOKS

Line 40: from fa_books a

36:
37: Cursor check_hr_asset is
38: select 'Y'
39: from ( select a.transaction_header_id_in
40: from fa_books a
41: , fa_asset_hierarchy b
42: where a.book_type_code = x_book_type_code
43: and a.asset_id = x_asset_id
44: and a.asset_id = b.asset_id

Line 46: fa_books c

42: where a.book_type_code = x_book_type_code
43: and a.asset_id = x_asset_id
44: and a.asset_id = b.asset_id
45: and a.date_ineffective IS NULL ) a1,
46: fa_books c
47: where c.transaction_header_id_out = a1.transaction_header_id_in
48: and nvl(c.period_counter_fully_retired, 0) <> 0;
49:
50: CURSOR check_status is