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 = :
AND p03_concorsi.test_id = :
AND p03_amm_conc.rinuncia_flg = 0
AND P03_AMM_CONC.TAX_PAG_FLG = 1