SELECT P01_ANAPER.cod_fis || ';' || num_compito || ';' || 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,
       p03_classif_dett
 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 p03_amm_conc.pers_id = p03_classif_dett.pers_id
       AND p03_amm_conc.pos_id = p03_classif_dett.pos_id
       AND p03_classif_dett.num_compito IS NOT NULL
       AND p03_concorsi.aa_id = :<AA_ID/>
       AND p03_concorsi.test_id = :<TEST_ID/>
       AND p03_amm_conc.rinuncia_flg = 0
       AND P03_AMM_CONC.TAX_PAG_FLG = 1