You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can i find which element link is associated with element entry?

Received Response


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!