DBA Data[Home] [Help]

APPS.FA_RECLASS_PVT dependencies on FA_TRANSACTION_HEADERS

Line 106: select fa_transaction_headers_s.nextval

102:
103: -- BUG# 3325400
104: -- forcing selection of the thid here rather
105: -- then relying on table handler
106: select fa_transaction_headers_s.nextval
107: into px_trans_rec.transaction_header_id
108: from dual;
109:
110: l_err_stage:= 'fa_distribution_pvt.do_distribution';

Line 373: FA_TRANSACTION_HEADERS TH

369:
370: CURSOR book_cr( p_asset_id number ) IS
371: SELECT TH.book_type_code
372: FROM FA_BOOK_CONTROLS BC,
373: FA_TRANSACTION_HEADERS TH
374: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION', 'GROUP ADDITION')
375: AND TH.asset_id = p_asset_id
376: AND BC.book_type_code = TH.book_type_code
377: AND nvl(BC.date_ineffective, sysdate + 1) > sysdate