DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 407: pay_element_links_f pel,

403: -- This cursor is tuned as part of performance bug fix 3420490.
404: cursor csr_get_assignment is
405: select distinct pee.assignment_id assignment_id, asg.assignment_number
406: from pay_element_entries_f pee,
407: pay_element_links_f pel,
408: per_all_assignments_f asg
409: where pee.element_type_id = p_plan_ele_type_id
410: and pee.element_type_id = pel.element_type_id
411: and pee.element_link_id = pel.element_link_id