792: RETURN DATE IS
793:
794: CURSOR cur_payroll_start IS
795: select start_date 796: from per_time_periods ptp 797: where payroll_id in (select payroll_id
798: from per_assignments_f
799: where assignment_id = p_assignment_id
800: and trunc(p_effective_date) between effective_start_date