Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF isConditionsPass = TRUE THEN
- FOR service_ IN (SELECT * FROM n_balances n WHERE n.account_id = given_id ) LOOP
- IF service_.service_id >= 900 AND service_.service_id <= 999 THEN
- isRestruct := TRUE;
- SELECT
- SUM(b.summ) INTO factsaldo
- FROM
- n_balances b
- WHERE b.account_id = given_id
- AND b.DATA = given_month
- AND service_id BETWEEN 900 AND 999;
- BEGIN
- SELECT
- NVL(RSlist.SUMMA, 0) INTO calcSaldo
- FROM
- n_restructuring_service_list RSlist
- JOIN n_restructuring_service rs ON rs.ID = rslist.n_restructuring_service_id
- WHERE rs.account_id = given_id
- AND rslist.DATA = given_month
- AND rs.service_id_out = 100;
- EXCEPTION WHEN NO_DATA_FOUND THEN
- calcsaldo := 0;
- --dbms_output.put_line('Нет данных в табилце n_restructuring_service_list по аккаунту '||given_id||' и дате '|| previous_month);
- END;
- END IF;
- END LOOP;
- IF isrestruct = FALSE THEN
- DBMS_OUTPUT.put_line('[ok]никакой реструкторизации');
- third_clause := TRUE;
- ELSE
- IF factsaldo <= calcsaldo THEN
- DBMS_OUTPUT.put_line('[ok]реструктуризация, factsaldo <= calcsaldo '||factsaldo||' <= '|| calcsaldo);
- third_clause := TRUE;
- ELSE
- DBMS_OUTPUT.put_line('[BREAK]реструктуризация, factsaldo > calcsaldo '||factsaldo||' > '||calcsaldo);
- third_clause := FALSE;
- isConditionsPass :=FALSE;
- END IF;
- END IF;
- END IF;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement