o/p 2

SELECT [ACCOUNT_MPL.MORTGAGE_BAL]

INTO [TEMP.MORTGAGE_BAL]

FROM [ACCOUNT_MPL]

WHERE [ACCOUNT_MPL.appl_num] = [appl_num]

AND [ACCOUNT_MPL.snapshot_month] = DATEADD(MONTH, -1, CURRENT_DATE);

IF UPPER(TRIM([V_SERVICING.LOAN_TYPE])) = 'MORTGAGE' THEN

    IF UPPER(TRIM([V_MORTGAGE_ACCOUNT_MANAGEMENT.SERVICING_STATUS])) <> 'DISCHARGED' THEN

        ASSIGN NVL([V_SERVICING.YTD_PREPAY_MADE], 0) TO [TEMP.CAL_YR_TO_DT_ADD_PAID_AMT];

    ELSE

        IF (YEAR(CURRENT_DATE) - YEAR([V_MORTGAGE_ACCOUNT_MANAGEMENT.EFFECTIVE_DATE_OF_DISCHARGE_ORG])) > 0 THEN

            ASSIGN 0 TO [TEMP.CAL_YR_TO_DT_ADD_PAID_AMT];

        ELSE

            ASSIGN NVL([V_SERVICING.YTD_PREPAY_MADE], 0) + 

                   (NVL([V_MORTGAGE_ACCOUNT_MANAGEMENT.CURRENT_PRINCIPAL_BAL], 0) - 

                   NVL([TEMP.MORTGAGE_BAL], 0)) TO [TEMP.CAL_YR_TO_DT_ADD_PAID_AMT];

        END IF;

    END IF;

END IF;

ASSIGN [TEMP.CAL_YR_TO_DT_ADD_PAID_AMT] TO [ACCOUNT_MPL.CAL_YR_TO_DT_ADD_PAID_AMT];