SELECT P01_ANAPER.cod_fis || ';' || p07_cla_murst.cod
  FROM p03_concorsi,
       p03_dett_test,
       p06_cds,
       p06_cla_cds,
       p07_cla_murst,
       P07_CLA_ATENEO,
       p03_amm_conc,
       P01_ANAPER
 WHERE     p03_concorsi.aa_id = p03_dett_test.aa_id
       AND p03_concorsi.test_id = p03_dett_test.test_id
       AND p03_dett_test.cds_id = p06_cds.cds_id
       AND P06_CDS.CDS_ID = P06_CLA_CDS.CDS_ID
       AND P06_CLA_CDS.CLA_A_ID = P07_CLA_ATENEO.CLA_A_ID
       AND P07_CLA_ATENEO.CLA_M_ID = P07_CLA_MURST.CLA_M_ID
       AND p06_cds.tipo_corso_cod = 'TFA'
       AND p03_concorsi.aa_id = P03_amm_conc.AA_ID
       AND p03_concorsi.test_id = P03_amm_conc.test_ID
       AND p03_amm_conc.pers_id = p01_anaper.pers_id
       AND P07_CLA_MURST.COD =
              DECODE (:<CODICE_CLASSE/>, '-1', P07_CLA_MURST.COD, :<CODICE_CLASSE/>)
       AND p03_concorsi.aa_id = :<AA_ID/>
       AND P03_AMM_CONC.TAX_PAG_FLG = 1
       AND EXISTS (select 1
       from p03_tfa_pref
       where p03_tfa_pref.aa_id = p03_amm_conc.aa_id
       and p03_tfa_pref.COD_FIS = p01_anaper.cod_fis
       and p03_tfa_pref.CODICE_CLASSE = P07_CLA_MURST.COD)
       AND EXISTS
              (SELECT 1
                 FROM p05_tax_amm
                WHERE     p05_tax_amm.pers_id = p03_amm_conc.pers_id
                      AND p05_tax_amm.pos_id = p03_amm_conc.pos_id
                      AND P05_TAX_AMM.DATA_PAGAMENTO BETWEEN :<DATA_INI_PAGAMENTO/> AND :<DATA_FINE_PAGAMENTO/>)