APPS.FA_ADJUSTMENT_PUB dependencies on FA_TRX_REFERENCES

Line 640: from fa_trx_references

636:
637: cursor c_get_max_reclass_date (p_asset_id number,
638: p_book_type_code varchar2) is
639: select dest_amortization_start_date
640: from fa_trx_references
641: where member_asset_id = p_asset_id
642: and book_type_code = p_book_type_code
643: order by dest_amortization_start_date desc;
644:

Line 1282: select fa_trx_references_s.nextval

1278: -- nvl(p_asset_fin_rec_adj.group_asset_id, -99)) then
1279: if (l_asset_fin_rec_old.group_asset_id is null and
1280: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or
1281: (l_asset_fin_rec_old.group_asset_id <> p_asset_fin_rec_adj.group_asset_id) then
1282: select fa_trx_references_s.nextval
1283: into px_trans_rec.trx_reference_id
1284: from dual;
1285: end if;
1286: