Data Dump of Element Entry

Summary

I want all the element entry values till date

Content

I want all the element entry values of the employee till date with correct effective date but facing issues with date

I using below query .Please let me now if I am missing any

Any help is highly appreciated

select screen_entry_value,a.effective_start_date,a.effective_end_date,b.effective_start_date as element_entry_start_date,b.effective_end_date as element_entry_end_date,element_name

from

Pay_element_entries_f b,

pay_element_entry_values_f a,

pay_element_types_f c,

pay_element_types_tl d