DBA Data[Home] [Help]

APPS.FA_TRANSFER_PUB dependencies on FA_TRANSACTION_HEADERS

Line 139: select fa_transaction_headers_s.nextval

135:
136: -- BUG# 3325400
137: -- forcing selection of the thid here rather
138: -- then relying on table handler
139: select fa_transaction_headers_s.nextval
140: into px_trans_rec.transaction_header_id
141: from dual;
142:
143: if not FA_DISTRIBUTION_PVT.do_distribution(

Line 360: FROM FA_TRANSACTION_HEADERS th,

356: -- check that only one prior period transfer is allowed in the same period
357:
358: SELECT count(1)
359: INTO l_count
360: FROM FA_TRANSACTION_HEADERS th,
361: FA_DEPRN_PERIODS dp
362: WHERE th.asset_id = nvl(p_asset_hdr_rec.asset_id, -1)
363: AND th.book_type_code = nvl(p_asset_hdr_rec.book_type_code,'XX')
364: AND th.transaction_type_code||'' = 'TRANSFER'