APPS.FARX_RP dependencies on FA_TRANSACTION_HEADERS

Line 685: FA_TRANSACTION_HEADERS TH

681: ORDER BY bk.book_type_code;
682: /*
683: SELECT TH.book_type_code
684: FROM FA_BOOK_CONTROLS BC,
685: FA_TRANSACTION_HEADERS TH
686: WHERE TH.transaction_type_code||'' IN ('ADDITION','CIP ADDITION')
687: AND TH.asset_id = a_tbl(a_index).asset_id
688: AND BC.book_type_code = TH.book_type_code
689: AND nvl(BC.date_ineffective, sysdate + 1) > sysdate

Line 1028: FA_TRANSACTION_HEADERS th

1024: -- Cursor to check whether the asset was added in the current open period.
1025: CURSOR added_this_period IS
1026: SELECT 'Y'
1027: FROM FA_DEPRN_PERIODS dp,
1028: FA_TRANSACTION_HEADERS th
1029: WHERE th.book_type_code = X_Book_Type_Code
1030: AND th.asset_id = X_Asset_Id
1031: AND th.transaction_type_code||'' in ('ADDITION', 'CIP ADDITION')
1032: AND dp.book_type_code = X_Book_Type_Code