995: -- ============================================================================
996: CURSOR c_get_retro_time_period(c_element_entry_id in number
997: ,c_assignment_id in number) IS
998: SELECT ptp.start_date,ptp.end_date
999: FROM per_time_periods ptp
1000: ,per_all_assignments_f paa
1001: WHERE paa.assignment_id = c_assignment_id
1002: AND ptp.payroll_id = paa.payroll_id
1003: AND pay_paywsmee_pkg.get_original_date_earned(c_element_entry_id)