firebird query parameter

donie

bro ada yg tau ga yah gmana caranya nampilin
bnyk dari query parameter,ak da bkin query parameter msalahnya ini query cman nampilin 1 record aj sesuai dengan parameter nya
gmana caranya agar bisa nampilin bnyk dengan sub query yg bnyk pula
---------------------------------------------------------------------------------------------
select
cardfile.perusahaan,
cardfile.webpages,
cardfile.alamat1,
pyr_marital.nama as statuskawin,
pyr_sex.nama as JENISKELAMIN,
pyr_tarifptkp.kode as KODEPTKP,
pyr_jabatan.nama as namajabatan,
min(pyr_gaji.bulan)AS AWALPERIODE,
max(pyr_gaji.bulan)AKHIRPERIODE,
sum(pyr_gaji.gajipokok)as gapok,
sum(pyr_gaji.tunjanganpph21/(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as tunjanganpph21,
sum(pyr_gaji.nilaipph21/(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as nilaipph21,
sum(pyr_gaji.nilaiptkp /(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun))as nilaiptkp,

(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=0) as nol,

(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=1) as satu,

(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=2) as dua,


(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=3) as tiga,

(SELECT SUM(PYR_GAJIDT1.NILAINOMINAL/(select count(pyr_gaji.noindex)from pyr_gaji where pyr_gaji.noindexcardfile=:aindexcardfile and pyr_gaji.tahun=:atahun)) from
pyr_gajidt1,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt1.noindexgaji = pyr_gaji.noindex and
pyr_gajidt1.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=4) as empat,



(SELECT SUM(PYR_GAJIDT2.NILAINOMINAL) from
pyr_gajidt2,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt2.noindexgaji = pyr_gaji.noindex and
pyr_gajidt2.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=5) as lima ,

(SELECT SUM(PYR_GAJIDT2.NILAINOMINAL) from
pyr_gajidt2,
pyr_gaji,pyr_tunjangan
where
pyr_gajidt2.noindexgaji = pyr_gaji.noindex and
pyr_gajidt2.noindextunjangan=pyr_tunjangan.noindex and
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and pyr_tunjangan.pyr_sptclass=6) as enam



from pyr_gaji,cardfile,pyr_marital,pyr_sex,pyr_tarifptkp,pyr_jabatan where
pyr_gaji.noindexcardfile=:Aindexcardfile and pyr_gaji.tahun=:atahun
and
cardfile.id=:aindexcardfile and
cardfile.pyr_marital=pyr_marital.noindex and
cardfile.pyr_sex=pyr_sex.noindex and
cardfile.pyr_tarifptkp=pyr_tarifptkp.noindex and
cardfile.pyr_jabatan=pyr_jabatan.noindex

group by cardfile.perusahaan,
cardfile.webpages,
cardfile.alamat1,
pyr_marital.nama,
pyr_sex.nama,
pyr_tarifptkp.kode,
pyr_jabatan.nama