440: IF p_transaction_type in ('RECLASS','CIP RECLASS') THEN
441: BEGIN
442: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,0)),0)
443: INTO p_adjustment
444: FROM fa_adjustments_mrc_v
445: WHERE book_type_code = p_book_type_code
446: AND asset_id = p_asset_id
447: AND period_counter_created = p_period_counter
448: AND source_type_code = l_source_type_code
454: ELSE
455: BEGIN
456: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1 * adjustment_amount)),0)
457: INTO p_adjustment
458: FROM fa_adjustments_mrc_v
459: WHERE book_type_code = p_book_type_code
460: AND asset_id = p_asset_id
461: AND period_counter_created = p_period_counter
462: AND source_type_code = l_source_type_code