APPS.HRENTMNT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1129: from pay_element_entry_values_f eev,

1125: iv.LOOKUP_TYPE,
1126: -- Bugfix 2827092
1127: iv.value_set_id,
1128: et.input_currency_code
1129: from pay_element_entry_values_f eev,
1130: pay_input_values_f iv,
1131: pay_element_types_f et
1132: where eev.element_entry_id = p_element_entry_id
1133: and iv.input_value_id = eev.input_value_id

Line 1671: update pay_element_entry_values_f eev

1667: ee.updating_action_type = decode(ee.updating_action_type, 'S', 'S', null)
1668: where ee.element_entry_id = p_element_entry_id
1669: and ee.effective_start_date = p_old_date;
1670: --
1671: update pay_element_entry_values_f eev
1672: set eev.effective_start_date = p_new_date
1673: where eev.element_entry_id = p_element_entry_id
1674: and eev.effective_start_date = p_old_date;
1675: --

Line 1687: update pay_element_entry_values_f eev

1683: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)
1684: where ee.element_entry_id = p_element_entry_id
1685: and ee.effective_end_date = p_old_date;
1686: --
1687: update pay_element_entry_values_f eev
1688: set eev.effective_end_date = p_new_date
1689: where eev.element_entry_id = p_element_entry_id
1690: and eev.effective_end_date = p_old_date;
1691: --

Line 2200: update pay_element_entry_values_f eev

2196: -- pay_element_entries_f, below, which *always* occurs.
2197: --
2198: l_ee_eed_out := l_calc_ee_eed;
2199: --
2200: update pay_element_entry_values_f eev
2201: set eev.effective_end_date = l_ee_eed_out
2202: where eev.element_entry_id = l_eeid_out;
2203: --
2204: end if;

Line 2492: delete from pay_element_entry_values_f eev

2488: p_ee_effective_start_date,
2489: p_ee_effective_end_date,
2490: p_entries_changed);
2491: --
2492: delete from pay_element_entry_values_f eev
2493: where eev.element_entry_id = p_element_entry_id
2494: and eev.effective_start_date >= p_ee_effective_start_date
2495: and eev.effective_end_date <= p_ee_effective_end_date;
2496: --

Line 2626: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev

2622: -- update first piece of REE that crosses eligibility boundary,
2623: -- do not delete as this REE cannot be recreated later,
2624: -- update its EED so that it is a day less than the VSD
2625: --
2626: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev
2627: SET eev.effective_end_date = p_validation_start_date - 1
2628: WHERE eev.element_entry_id = p_element_entry_id
2629: and eev.effective_start_date < p_validation_start_date
2630: -- Change 115.60

Line 2756: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev

2752: -- update piece of REE that crosses eligibility boundary,
2753: -- do not delete as this REE cannot be recreated later,
2754: -- update its EED so that it is a day greater than the VSD
2755: --
2756: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev
2757: SET eev.effective_start_date = p_validation_end_date + 1
2758: WHERE eev.element_entry_id = p_element_entry_id
2759: -- Change 115.60
2760: -- and eev.effective_start_date < p_validation_end_date

Line 2820: delete from pay_element_entry_values_f eev

2816: -- Remove orphaned entries and entry values
2817: --
2818: for v_entry in csr_orphaned_entries(p_assignment_id) loop
2819: --
2820: delete from pay_element_entry_values_f eev
2821: where eev.element_entry_id = v_entry.element_entry_id;
2822: --
2823: delete from pay_element_entries_f ee
2824: where ee.element_entry_id = v_entry.element_entry_id;

Line 3109: /* delete from pay_element_entry_values_f eev

3105: ,p_effective_end_date =>l_eff_end_date
3106: ,p_delete_warning =>l_del_war);
3107:
3108: --Commented the below code as part of 6809717
3109: /* delete from pay_element_entry_values_f eev
3110: where eev.element_entry_id = v_entry.element_entry_id;
3111: --
3112: delete from pay_element_entries_f ee
3113: where ee.element_entry_id = v_entry.element_entry_id;*/

Line 4968: delete from pay_element_entry_values_f eev

4964: p_entries_changed);
4965: --
4966: -- Remove element entry values.
4967: --
4968: delete from pay_element_entry_values_f eev
4969: where eev.element_entry_id = v_entry.element_entry_id
4970: and eev.effective_start_date = v_entry.effective_start_date
4971: and eev.effective_end_date = v_entry.effective_end_date;
4972: --

Line 7109: update pay_element_entry_values_f

7105: AND r_entry.updating_action_id IS NULL THEN -- bug 7315564
7106:
7107: hr_utility.set_location(l_proc,60);
7108:
7109: update pay_element_entry_values_f
7110: set effective_end_date = l_new_eed
7111: where element_entry_id = r_entry.element_entry_id
7112: and p_old_final_process_date between effective_start_date and effective_end_date;
7113:

Line 7128: update pay_element_entry_values_f

7124: if r_entry.effective_end_date > l_new_final_process_date then
7125:
7126: hr_utility.set_location(l_proc,70);
7127:
7128: update pay_element_entry_values_f
7129: set effective_end_date = l_new_eed
7130: where element_entry_id = r_entry.element_entry_id
7131: and p_old_final_process_date between effective_start_date and effective_end_date
7132: and l_new_eed >= effective_start_date;