DBA Data[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_LINKS

Line 788: FROM pay_element_links el, pay_element_entries ee

784: CURSOR csr_entries (p_assignment_id NUMBER
785: ,p_element_type_id NUMBER
786: ,p_entry_id IN NUMBER) IS
787: SELECT ee.element_entry_id, ee.entry_type, el.element_link_id
788: FROM pay_element_links el, pay_element_entries ee
789: WHERE el.ELEMENT_TYPE_ID = p_element_type_id
790: AND ee.ELEMENT_LINK_ID = el.ELEMENT_LINK_ID
791: AND ee.ASSIGNMENT_ID = p_assignment_id
792: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))