APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_ENTRIES

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))

Line 806: From pay_element_entries ee

802: Where cer.ASSIGNMENT_ID = p_assignment_id
803: and cer.end_date is null --fix for bug 5747086
804: and cer.element_type_id = p_element_type_id -- Bug 14096456
805: And not exists (select 1
806: From pay_element_entries ee
807: Where cer.assignment_id = ee.assignment_id
808: And cer.element_type_id = ee.element_type_id
809: And ee.element_type_id = p_element_type_id
810: And p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE

Line 851: FROM pay_element_entries_f

847: AND cei.cagr_entitlement_item_id = p_entitlement_id;
848:
849: CURSOR csr_ele_entries (p_assignment_id number,p_element_type_id number,p_end_date date) is
850: SELECT element_entry_id,object_version_number
851: FROM pay_element_entries_f
852: WHERE element_type_id=p_element_type_id
853: AND assignment_id=p_assignment_id
854: AND effective_start_date<=p_end_date
855: AND effective_end_date>p_end_date

Line 971: get_ovn_and_mode (p_table_name => 'PAY_ELEMENT_ENTRIES_F'

967: fetch csr_entries into v_entries;
968: exit when csr_entries%notfound;
969:
970: -- determine the ovn, dt mode for the ele entry in this iteration
971: get_ovn_and_mode (p_table_name => 'PAY_ELEMENT_ENTRIES_F'
972: ,p_dt_flag => 'Y'
973: ,p_pk => 'ELEMENT_ENTRY_ID'
974: ,p_pk_id => v_entries.element_entry_id
975: ,p_effective_date => p_params.effective_date