DBA Data[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

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