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 234: FA_TRANSACTION_HEADERS TH

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

Line 244: from FA_TRANSACTION_HEADERS TH,

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