62: -- Declare cursors and local variables
63: --
64: CURSOR period_csr IS
65: SELECT ptp.start_date, ptp.end_Date
66: FROM per_time_periods ptp, per_all_assignments_f paa
67: WHERE paa.assignment_id = p_assignment_id
68: AND paa.payroll_id = ptp.payroll_id
69: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date;
70: --
357: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
358: --
359: CURSOR period_csr IS
360: SELECT ptp.start_date, ptp.end_Date
361: FROM per_time_periods ptp, per_all_assignments_f paa
362: WHERE paa.assignment_id = l_assignment_id
363: AND paa.payroll_id = ptp.payroll_id
364: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date;
365: --