APPS.FA_SORP_IMPAIRMENT_PVT dependencies on FA_MC_ITF_IMPAIRMENTS

Line 421: from fa_mc_itf_impairments

417: , ASSET_ID
418: , SPLIT1_IMPAIR_CLASS
419: , SPLIT2_IMPAIR_CLASS
420: , SPLIT3_IMPAIR_CLASS
421: from fa_mc_itf_impairments
422: where impairment_id = c_impairment_id
423: and book_type_code = c_book_type_code
424: and nvl(goodwill_asset_flag, 'N') <> 'Y'
425: and set_of_books_id = p_set_of_books_id;

Line 723: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

719: -- If the revaluation reserve is zero then calculation of the
720: -- revaluation reserve impact is not required
721: -- Update the interface table with the split impairment details
722: IF (p_mrc_sob_type_code = 'R') THEN
723: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
724: SET SPLIT1_LOSS_AMOUNT = l_split1_loss_amount
725: , SPLIT2_LOSS_AMOUNT = l_split2_loss_amount
726: , SPLIT3_LOSS_AMOUNT = l_split3_loss_amount
727: , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)

Line 807: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

803: -- Once revaluation reserve is consumed, update the
804: -- interface table with the values
805: IF t_split_process_order(j).split_number = 1 THEN
806: IF (p_mrc_sob_type_code = 'R') THEN
807: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
808: SET SPLIT1_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
809: - t_split_process_order(j).reval_reserve
810: , SPLIT1_REVAL_RESERVE = t_split_process_order(j).reval_reserve
811: , SPLIT1_PROCESS_ORDER = j

Line 831: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

827: END IF;
828: END IF;
829: IF t_split_process_order(j).split_number = 2 THEN
830: IF (p_mrc_sob_type_code = 'R') THEN
831: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
832: SET SPLIT2_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
833: - t_split_process_order(j).reval_reserve
834: , SPLIT2_REVAL_RESERVE = t_split_process_order(j).reval_reserve
835: , SPLIT2_PROCESS_ORDER = j

Line 855: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

851: END IF;
852: END IF;
853: IF t_split_process_order(j).split_number = 3 THEN
854: IF (p_mrc_sob_type_code = 'R') THEN
855: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
856: SET SPLIT3_LOSS_AMOUNT = t_split_process_order(j).split_loss_amount
857: - t_split_process_order(j).reval_reserve
858: , SPLIT3_REVAL_RESERVE = t_split_process_order(j).reval_reserve
859: , SPLIT3_PROCESS_ORDER = j

Line 882: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

878:
879: -- Update the interface table with the remaining
880: -- revaluation reserve left after consumption
881: IF (p_mrc_sob_type_code = 'R') THEN
882: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
883: SET YTD_IMPAIRMENT = NVL(YTD_IMPAIRMENT,0) - (IMPAIRMENT_AMOUNT-
884: (NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)))
885: , IMPAIRMENT_AMOUNT = NVL(SPLIT1_LOSS_AMOUNT,0) + NVL(SPLIT2_LOSS_AMOUNT,0) + NVL(SPLIT3_LOSS_AMOUNT,0)
886: , REVAL_RESERVE_ADJ_AMOUNT = REVAL_RESERVE - t_reval_reserve(i)

Line 931: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

927: ELSE -- Impairment is not split
928:
929: IF t_reval_reserve(i) <> 0 THEN
930: IF (p_mrc_sob_type_code = 'R') THEN
931: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
932: SET
933: REVAL_RESERVE = NVL(REVAL_RESERVE,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
934: , REVAL_RESERVE_ADJ_AMOUNT = least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)
935: , CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0) - least(REVAL_RESERVE, IMPAIRMENT_AMOUNT)

Line 978: UPDATE FA_MC_ITF_IMPAIRMENTS ITF

974: AND nvl(GOODWILL_ASSET_FLAG, 'N') <> 'Y';
975: END IF;
976: ELSE -- If t_reval_reserve(i) = 0
977: IF (p_mrc_sob_type_code = 'R') THEN
978: UPDATE FA_MC_ITF_IMPAIRMENTS ITF
979: SET CAPITAL_ADJUSTMENT = NVL(CAPITAL_ADJUSTMENT,0) + NVL(IMPAIRMENT_AMOUNT,0)
980: + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)
981: , GENERAL_FUND = NVL(GENERAL_FUND,0) + NVL(IMPAIRMENT_AMOUNT,0)
982: + NVL(DEPRN_ADJUSTMENT_AMOUNT,0)