1070: -- nonrecurring element entry
1071: CURSOR period_end (p_asg_id in NUMBER,
1072: p_start_date in DATE) IS
1073: SELECT ptp.end_date 1074: FROM per_time_periods ptp, 1075: per_all_assignments_f paaf
1076: WHERE paaf.assignment_id = p_asg_id
1077: AND p_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
1078: AND paaf.payroll_id = ptp.payroll_id