CREATE GLOBAL TEMPORARY TABLE RCALC_TEMP_ACCOUNT_ABON (
    CODE            TCODENN NOT NULL /* TCODENN = INTEGER NOT NULL */,
    ACCOUNT_CODE    TACCOUNT /* TACCOUNT = BIGINT */,
    CALC_PD_FROM    TCODE /* TCODE = INTEGER */,
    CALC_PD_TILL    TCODE /* TCODE = INTEGER */,
    SERVICE_CODE    TCODE /* TCODE = INTEGER */,
    CALC_DATE_FROM  TDATE /* TDATE = DATE */,
    CALC_DATE_TILL  TDATE /* TDATE = DATE */,
    HOUSE_CODE      TCODE /* TCODE = INTEGER */
) ON COMMIT DELETE ROWS;

ALTER TABLE RCALC_TEMP_ACCOUNT_ABON ADD CONSTRAINT PK_RCALC_TEMP_ACCOUNT_ABON PRIMARY KEY (CODE);

CREATE INDEX RCALC_TEMP_ACCOUNT_ABON_IDX1 ON RCALC_TEMP_ACCOUNT_ABON (HOUSE_CODE);

select L10.Account_Code, L10.Calc_Pd_From
        from Rcalc_Temp_Account_Abon L10
        where L10.Service_Code = :A_Service_Code
          and L10.House_Code = :A_House_Code

PLAN (L10 INDEX (RCALC_TEMP_ACCOUNT_ABON_IDX1))