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

Need to pull dates from a component

Summary:

Need to pull dates Im pointing to in the image using a value set lookup. I need to find the table for those dates and the join path.

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable): 26A

Code Snippet (add any code snippets that support your topic, if applicable):

Hold my beer, Tables:

pay_element_entries_f paef, pay_element_entry_values_f peev, pay_input_values_f piv, pay_element_types_vl pet, per_all_people_f ppf

WHERE:

paef.element_entry_id = peev.element_entry_id
AND peev.input_value_id = piv.input_value_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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