2020: int.DATE_TO pay_to,
2021: int.INFORMATION1 person_id,
2022: int.INFORMATION2 total_pay,
2023: int.INFORMATION3 lump_sum 2024: FROM GHR_INTERFACE int 2025: WHERE int.SOURCE_NAME = 'PAYROLL'
2026: AND int.date_from BETWEEN p_pay_from and p_pay_to;
2027:
2028: CURSOR c_numb (l_person_id NUMBER) IS