DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on DUAL

Line 337: from dual;

333:
334: if (nvl(px_inv_trans_rec.transaction_type, 'X') <> 'INVOICE TRANSFER') then
335: select fa_transaction_headers_s.nextval
336: into px_trans_rec.transaction_header_id
337: from dual;
338: end if;
339:
340: -- also check if this is the period of addition - use absolute mode for adjustments
341: -- we will only clear cost outside period of addition

Line 442: from dual;

438: -- note that we do it here rather than do_all
439: -- books because of invoice impacts in corp above
440: select fa_transaction_headers_s.nextval
441: into l_trans_rec.transaction_header_id
442: from dual;
443:
444: if not do_all_books
445: (px_trans_rec => l_trans_rec, -- tax
446: px_asset_hdr_rec => l_asset_hdr_rec , -- tax

Line 1284: from dual;

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:
1287: -- BUG# 2877651
1288: -- if this is or was a amember asset, force amortized subtype

Line 1943: from dual;

1939: end if;
1940:
1941: select fa_transaction_headers_s.nextval
1942: into l_src_trans_rec.transaction_header_id
1943: from dual;
1944:
1945: end if;
1946:
1947: