To find Screen Entry Value from Element and Element Link Definition

SELECT peev.screen_entry_value
FROM pay_element_types_f pet,
pay_input_values_f piv,
--pay_element_links_f pel,
pay_element_entries_f pee,
pay_element_entry_values_f peev
WHERE 1 =1
and pet.element_type_id = piv.element_type_id
--AND piv.element_type_id = pel.element_type_id
-- AND pel.element_link_id = pee.element_link_id
and pee.element_entry_id=peev.element_entry_id
and pet.element_type_id = pee.element_type_id
and piv.input_value_id=peev.input_value_id
AND pee.assignment_id = p_assignment_id
AND piv.name = p_input_name
AND pet.element_name = p_element_name
AND p_start_date BETWEEN pet.effective_start_date AND pet.effective_end_date
and p_start_date between piv.effective_start_date and piv.effective_end_date
--AND p_start_date BETWEEN pel.effective_start_date AND pel.effective_end_date
AND p_start_date BETWEEN pee.effective_start_date AND pee.effective_end_date
AND p_start_date BETWEEN peev.effective_start_date AND peev.effective_end_date;