SELECT P01_ANAPER.cod_fis|| ';'
       || (SELECT P03_TFA_PREF.CODICE_REGISTRAZIONE
FROM p03_tfa_pref, p03_dett_test,
p06_cds,
p06_cla_cds,
p07_cla_murst,
P07_CLA_ATENEO
WHERE p03_tfa_pref.cod_fis = p01_anaper.cod_fis
AND p03_tfa_pref.aa_id = p03_amm_conc.aa_id
AND p03_amm_conc.aa_id = p03_dett_test.aa_id
and p03_amm_conc.tipo_cat_amm_id = p03_dett_test.tipo_cat_amm_id
AND p03_amm_conc.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 P03_TFA_PREF.CODICE_CLASSE = P07_CLA_MURST.COD
and rownum = 1)
  FROM p03_amm_conc JOIN p01_anaper on p03_amm_conc.pers_id = p01_anaper.pers_id
 WHERE p03_amm_conc.rinuncia_flg = 0
   AND p03_amm_conc.conf_esplicita = 1
   AND P03_AMM_CONC.TAX_PAG_FLG = 1
   AND p03_amm_conc.aa_id = :<AA_ID/>
   AND p03_amm_conc.test_id = :<TEST_ID/>
   AND (p03_amm_conc.tipo_cat_amm_id IS NULL
    OR p03_amm_conc.tipo_cat_amm_id = decode(:<TIPO_CAT_AMM_ID/>, '*', p03_amm_conc.tipo_cat_amm_id, :<TIPO_CAT_AMM_ID/>))
       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/>)