DBA Data[Home] [Help]

APPS.PER_CAGR_APPLY_RESULTS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

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