Run-Control link to main select

[Jane Bond <virgo007uk@YAHOO.CO.UK>]

Hi Guys,

I have just finished my first SQR but i need some
help.

My run-control panel is to allow x number of absences
to be chosen eg 1,2 etc

how do i link my run-control number. called
Periods(see below) with the SQL below

begin-procedure Select-Parameters

begin-SELECT

 display 'entering Run Parms'

A1.OPRID
A1.RUN_CNTL_ID
A1.ASOFDATE
A1.FROMDATE
A1.THRUDATE
A1.DEPTID
A1.PERIODS <--------

 #debuga show &A1.RUN_CNTL_ID

 do Get-Values

FROM PS_RCNTL A1
WHERE A1.OPRID = $prcs_oprid
  AND A1.RUN_CNTL_ID = $prcs_run_cntl_id

end-SELECT

end-procedure


COUNT (*)               &Absence  <-------

FROM PS_EMPLOYEES A, PS_ABSENCE_HIST B, PS_JOB C
  WHERE A.EMPLID = B.EMPLID
    AND A.EMPL_RCD# = B.EMPL_RCD#
     AND B.EMPLID = C.EMPLID
     AND B.EMPL_RCD# = C.EMPL_RCD#
     AND C.EFFDT =
        (SELECT MAX(C_ED.EFFDT) FROM PS_JOB C_ED
        WHERE C.EMPLID = C_ED.EMPLID
          AND C.EMPL_RCD# = C_ED.EMPL_RCD#
          AND C_ED.EFFDT <=SYSDATE)
     AND C.SETID_DEPT = 'UKPFE'
     AND C.REG_REGION = 'GBR'
     AND C.EMPL_STATUS = 'A'
         AND A.NATIONAL_ID_TYPE = 'LC'
         AND A.NID_COUNTRY = 'GBR'
     AND A.DEPTID  = $DeptId
GROUP BY
A.BUSINESS_UNIT,A.EMPL_RCD#,B.EMPLID,A.NAME,A.JOBCODE,
A.JOBTITLE,A.DEPTID,A.DEPTNAME

How do i link &absence to A1.periods in the run
control. I have tried everything.

Thanks

Jane

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie