APPS.FARX_RP dependencies on FA_TRANSACTION_HEADERS

Line 662: FA_TRANSACTION_HEADERS TH

658: ORDER BY bk.book_type_code;
659: /*
660: SELECT TH.book_type_code
661: FROM FA_BOOK_CONTROLS BC,
662: FA_TRANSACTION_HEADERS TH
663: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION')
664: AND TH.asset_id = a_tbl(a_index).asset_id
665: AND BC.book_type_code = TH.book_type_code
666: AND nvl(BC.date_ineffective, sysdate + 1) > sysdate

Line 999: FA_TRANSACTION_HEADERS th

995: -- Cursor to check whether the asset was added in the current open period.
996: CURSOR added_this_period IS
997: SELECT 'Y'
998: FROM FA_DEPRN_PERIODS dp,
999: FA_TRANSACTION_HEADERS th
1000: WHERE th.book_type_code = X_Book_Type_Code
1001: AND th.asset_id = X_Asset_Id
1002: AND th.transaction_type_code||'' in ('ADDITION', 'CIP ADDITION')
1003: AND dp.book_type_code = X_Book_Type_Code