1988: int.DATE_TO pay_to,
1989: int.INFORMATION1 person_id,
1990: int.INFORMATION2 total_pay,
1991: int.INFORMATION3 lump_sum 1992: FROM GHR_INTERFACE int 1993: WHERE int.SOURCE_NAME = 'PAYROLL'
1994: AND int.date_from BETWEEN p_pay_from and p_pay_to;
1995:
1996: CURSOR c_numb (l_person_id NUMBER) IS