DBA Data[Home] [Help]

APPS.FA_TRANSFER_PUB dependencies on FA_TRANSACTION_HEADERS

Line 184: select fa_transaction_headers_s.nextval

180:
181: -- BUG# 3325400
182: -- forcing selection of the thid here rather
183: -- then relying on table handler
184: select fa_transaction_headers_s.nextval
185: into px_trans_rec.transaction_header_id
186: from dual;
187:
188: -- Bug 15877517 : Reinitialize who_info as well

Line 406: FROM FA_TRANSACTION_HEADERS th,

402: -- check that only one prior period transfer is allowed in the same period
403:
404: SELECT count(1)
405: INTO l_count
406: FROM FA_TRANSACTION_HEADERS th,
407: FA_DEPRN_PERIODS dp
408: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
409: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
410: AND th.transaction_type_code||'' = 'TRANSFER'

Line 452: FROM FA_TRANSACTION_HEADERS th,

448: we should not allow this backdated transfer in Corp Book. */
449: if (g_release = 11) then --Brahma
450: SELECT count(1)
451: INTO l_count
452: FROM FA_TRANSACTION_HEADERS th,
453: FA_DEPRN_PERIODS dp,
454: FA_BOOK_CONTROLS bc
455: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
456: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')