APPS.FA_RETIRE_PKG dependencies on FA_TRANSACTION_HEADERS

Line 124: FROM FA_TRANSACTION_HEADERS TH,

120: AND Fiscal_Year_Name = LV_Fiscal_Year_Name;
121: -- Check when asset was added
122: SELECT dp.period_counter
123: INTO X_Asset_Added_PC
124: FROM FA_TRANSACTION_HEADERS TH,
125: FA_DEPRN_PERIODS DP
126: WHERE TH.ASSET_ID = X_ASSET_ID
127: AND TH.BOOK_TYPE_CODE = X_BOOK_TYPE_CODE
128: AND TH.TRANSACTION_TYPE_CODE||'' =

Line 138: FROM fa_transaction_headers

134:
135: -- commenting for bug 3768867
136: /*SELECT max(transaction_date_entered)
137: INTO X_Max_Transaction_Date_Entered
138: FROM fa_transaction_headers
139: WHERE asset_id = X_Asset_Id
140: and book_type_code = X_Book_Type_Code
141: and transaction_type_code not in ('REINSTATEMENT','FULL RETIREMENT')
142: and transaction_type_code not like '%/VOID';*/ -- bug2107509