APPS.FA_MASS_DPR_RSV_ADJ_PKG dependencies on FA_TRANSACTION_HEADERS

Line 108: FA_TRANSACTION_HEADERS TH

104: AD.CURRENT_UNITS */ --vmarella .
105: FROM FA_DEPRN_SUMMARY DS,
106: FA_BOOKS BK,
107: FA_ADDITIONS AD,
108: FA_TRANSACTION_HEADERS TH
109: WHERE DS.BOOK_TYPE_CODE = g_adj_asset_hdr_rec.book_type_code
110: AND DS.ASSET_ID = AD.ASSET_ID
111: AND (DS.PERIOD_COUNTER BETWEEN g_start_pc AND g_end_pc)
112: AND BK.ASSET_ID = AD.ASSET_ID

Line 232: FA_TRANSACTION_HEADERS TH

228: DISTINCT 1
229: INTO
230: l_is_retired
231: FROM
232: FA_TRANSACTION_HEADERS TH
233: WHERE
234: TH.ASSET_ID = g_adj_asset_hdr_rec.asset_id AND
235: TH.BOOK_TYPE_CODE = g_adj_asset_hdr_rec.book_type_code AND
236: TH.TRANSACTION_TYPE_CODE = 'FULL RETIREMENT';

Line 242: from FA_TRANSACTION_HEADERS TH,

238: when no_data_found then
239: begin
240: select distinct 1
241: into l_is_retired
242: from FA_TRANSACTION_HEADERS TH,
243: FA_DEPRN_PERIODS DP1,
244: FA_DEPRN_PERIODS DP2
245: where TH.asset_id = g_adj_asset_hdr_rec.asset_id
246: and TH.book_type_code = g_adj_asset_hdr_rec.book_type_code