APPS.FA_ADJUSTMENT_PUB dependencies on FA_TRX_REFERENCES

Line 685: from fa_trx_references

681:
682: cursor c_get_max_reclass_date (p_asset_id number,
683: p_book_type_code varchar2) is
684: select dest_amortization_start_date
685: from fa_trx_references
686: where member_asset_id = p_asset_id
687: and book_type_code = p_book_type_code
688: order by dest_amortization_start_date desc;
689:

Line 820: from fa_trx_references

816: SRC_EXPENSE_AMOUNT,
817: DEST_EXPENSE_AMOUNT,
818: SRC_EOFY_RESERVE,
819: DEST_EOFY_RESERVE
820: from fa_trx_references
821: where TRX_REFERENCE_ID = px_trans_rec.trx_reference_id;
822:
823: l_trx_ref_rec fa_api_types.trx_ref_rec_type; --Bug 8941132
824: l_group_reclass boolean := FALSE; --Bug 8941132

Line 1541: select fa_trx_references_s.nextval

1537: -- nvl(l_asset_fin_rec_adj.group_asset_id, -99)) then
1538: if (l_asset_fin_rec_old.group_asset_id is null and
1539: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or
1540: (l_asset_fin_rec_old.group_asset_id <> l_asset_fin_rec_adj.group_asset_id) then
1541: select fa_trx_references_s.nextval
1542: into px_trans_rec.trx_reference_id
1543: from dual;
1544: end if;
1545: