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 = :
AND p03_amm_conc.test_id = :
AND (p03_amm_conc.tipo_cat_amm_id IS NULL
OR p03_amm_conc.tipo_cat_amm_id = decode(:, '*', p03_amm_conc.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 : AND :)