DBA Data[Home] [Help]

APPS.FA_RECLASS_PVT dependencies on FA_TRANSACTION_HEADERS

Line 99: select fa_transaction_headers_s.nextval

95:
96: -- BUG# 3325400
97: -- forcing selection of the thid here rather
98: -- then relying on table handler
99: select fa_transaction_headers_s.nextval
100: into px_trans_rec.transaction_header_id
101: from dual;
102:
103: -- Bug 15877517 : Reinitialize who_info as well

Line 351: FA_TRANSACTION_HEADERS TH

347:
348: CURSOR book_cr( p_asset_id number ) IS
349: SELECT TH.book_type_code
350: FROM FA_BOOK_CONTROLS BC,
351: FA_TRANSACTION_HEADERS TH
352: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION', 'GROUP ADDITION')
353: AND TH.asset_id = p_asset_id
354: AND BC.book_type_code = TH.book_type_code
355: AND nvl(BC.date_ineffective, sysdate + 1) > sysdate