DBA Data[Home] [Help]

APPS.FA_MASS_DPR_RSV_ADJ_PKG dependencies on FA_DEPRN_PERIODS

Line 245: FA_DEPRN_PERIODS DP1,

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
249: and TH.transaction_type_code = 'PARTIAL RETIREMENT'

Line 246: FA_DEPRN_PERIODS DP2

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
249: and TH.transaction_type_code = 'PARTIAL RETIREMENT'
250: and DP1.period_counter = g_start_pc and