select par.TASKNAME as Vorhaben, t.PSPCODE as 'PSP-Element',t.TASKNAME as 'Arbeitspaket'

  from CCTASK t

    left outer join CCTASK par on par.TASKID=t.PARENTID

  where t.PROJECT=? and t.TASKTYPE='JAPAP'