DBA Data[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_LINKS

Line 780: FROM pay_element_links el, pay_element_entries ee

776: CURSOR csr_entries (p_assignment_id NUMBER
777: ,p_element_type_id NUMBER
778: ,p_entry_id IN NUMBER) IS
779: SELECT ee.element_entry_id, ee.entry_type, el.element_link_id
780: FROM pay_element_links el, pay_element_entries ee
781: WHERE el.ELEMENT_TYPE_ID = p_element_type_id
782: AND ee.ELEMENT_LINK_ID = el.ELEMENT_LINK_ID
783: AND ee.ASSIGNMENT_ID = p_assignment_id
784: AND (p_entry_id is null or (p_entry_id is not null and ee.element_entry_id = p_entry_id))