How can i find which element link is associated with element entry?
Summary:
I am trying to create a query to find DFF values in element link table for an element entry. For an element, there is 3 eligibilities setup. So, my query is pulling 3 rows for an element entry (element entry * no of eligibility). How do i know which eligibility satisfies for the element entry?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
select pel.*
from pay_element_entries_f pee , pay_element_types_vl pet , pay_element_links_f pel , pay_cost_allocations_f pca
where pee.element_entry_id = 100003053328750
0