DBA Data[Home] [Help]

APPS.PER_IN_PERQUISITE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 123: ,pay_element_links_f links

119: ,pet.element_type_id
120: ,pee.assignment_id
121: FROM pay_element_entries_f pee
122: ,pay_element_types_f pet
123: ,pay_element_links_f links
124: WHERE pee.element_entry_id = p_element_entry_id
125: AND pet.element_type_id = links.element_type_id
126: AND links.element_link_id = pee.element_link_id
127: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date