DBA Data[Home] [Help]

APPS.FA_MASS_DPR_RSV_ADJ_PKG dependencies on FA_DEPRN_PERIODS

Line 243: FA_DEPRN_PERIODS DP1,

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

Line 244: FA_DEPRN_PERIODS DP2

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