APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_ENTRIES

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

Line 797: From pay_element_entries ee

793: From per_cagr_entitlement_results cer
794: Where cer.ASSIGNMENT_ID = p_assignment_id
795: and cer.end_date is null --fix for bug 5747086
796: And not exists (select 1
797: From pay_element_entries ee
798: Where cer.assignment_id = ee.assignment_id
799: And cer.element_type_id = ee.element_type_id
800: And ee.element_type_id = p_element_type_id
801: And p_params.effective_date BETWEEN ee.EFFECTIVE_START_DATE

Line 842: FROM pay_element_entries_f

838: AND cei.cagr_entitlement_item_id = p_entitlement_id;
839:
840: CURSOR csr_ele_entries (p_assignment_id number,p_element_type_id number,p_end_date date) is
841: SELECT element_entry_id,object_version_number
842: FROM pay_element_entries_f
843: WHERE element_type_id=p_element_type_id
844: AND assignment_id=p_assignment_id
845: AND effective_start_date<=p_end_date
846: AND effective_end_date>p_end_date;

Line 961: get_ovn_and_mode (p_table_name => 'PAY_ELEMENT_ENTRIES_F'

957: fetch csr_entries into v_entries;
958: exit when csr_entries%notfound;
959:
960: -- determine the ovn, dt mode for the ele entry in this iteration
961: get_ovn_and_mode (p_table_name => 'PAY_ELEMENT_ENTRIES_F'
962: ,p_dt_flag => 'Y'
963: ,p_pk => 'ELEMENT_ENTRY_ID'
964: ,p_pk_id => v_entries.element_entry_id
965: ,p_effective_date => p_params.effective_date