v_domain          NUMBER;
  v_group           NUMBER;
  v_client          NUMBER;
  v_account         NUMBER;
  v_service         NUMBER;
  v_balance         NUMBER;
  v_expired         DATE;
  v_amount          NUMBER;
  v_duration        NUMBER;
  v_str             VARCHAR2(500);

...
    select C.DOMAIN_ID, C.GROUP_ID, C.CUSTOMER_ID, A.ACCOUNT_ID
    , case
        ... (строковые результаты)
      end as "INVALID"
    , A.MONEY as "BALANCE"
    , S.ROOT_ID as "SERVICE_ID"
    , S.D as "PERIOD"
    , ceil(S.SUM) as "AMOUNT"
    , S.D - trunc(sysdate) as "DAYS"
    into v_domain, v_group, v_client, v_account
    , v_str
    , v_balance
    , v_service
    , v_expired
    , v_amount
    , v_duration