428: FROM
429: PAY_ALL_PAYROLLS_F PAP,
430: PER_TIME_PERIODS PTP,
431: PAY_PAYROLL_ACTIONS PPA,
432: HR_LOOKUPS HRL
433: WHERE PPA.PAYROLL_ACTION_ID = C_PAYROLL_ACTION_ID
434: AND PAP.PAYROLL_ID = PPA.PAYROLL_ID
435: AND PAP.PAYROLL_ID = PTP.PAYROLL_ID
436: AND PPA.DATE_EARNED between PTP.START_DATE