Retro Entries

select ptp.period_name,to_char(ptp.start_date, 'DD-MON-RRRR') start_date,to_char(ptp.end_date, 'DD-MON-RRRR') end_date,pay.payroll_name,et.element_name,per.employee_number,per.last_name,per.first_name,to_number(prv.result_value),prr.status,decode (pee.creator_type,'RR','Y','N') retroactive_flag,pee.source_end_date original_datefrom per_time_periods ptp,pay_payrolls_f pay,pay_payroll_actions ppa,pay_assignment_actions pac,pay_element_types_f et,pay_run_results prr,pay_run_result_values prv,pay_input_values_f piv ,per_assignments_f ass,per_people_x per,pay_element_entries_f peewhere pay.payroll_name = NVL(:p_payroll_name ,pay.payroll_name)and pay.payroll_id = ptp.payroll_idand ptp.period_name like '8 2006%'and ptp.payroll_id = ppa.payroll_idand ppa.action_type in ( 'R', 'Q')and ppa.date_earned between ptp.start_date and ptp.end_dateand ppa.payroll_action_id = pac.payroll_action_idand pac.assignment_action_id = prr.assignment_action_idand pac.assignment_id = 227and ass.assignment_id = pac.assignment_idand ptp.end_date between ass.effective_start_date and ass.effective_end_dateand et.element_name like 'R%'and ptp.start_date between et.effective_start_date and et.effective_end_dateand piv.element_type_id = et.element_type_idand piv.name = 'Pay Value'and prv.input_value_id = piv.input_value_idand ptp.start_date between piv.effective_start_date and piv.effective_end_dateand prv.run_result_id = prr.run_result_idand prr.element_type_id = et.element_type_idand per.person_id = ass.person_idand pee.element_entry_id = prr.element_entry_idand ptp.end_date between pee.effective_start_date and pee.effective_end_date