985: iv.LOOKUP_TYPE,
986: -- Bugfix 2827092
987: iv.value_set_id,
988: et.input_currency_code
989: from pay_element_entry_values_f eev,
990: pay_input_values_f iv,
991: pay_element_types_f et
992: where eev.element_entry_id = p_element_entry_id
993: and iv.input_value_id = eev.input_value_id
1904: ee.updating_action_type = decode(ee.updating_action_type, 'S', 'S', null)
1905: where ee.element_entry_id = p_element_entry_id
1906: and ee.effective_start_date = p_old_date;
1907: --
1908: update pay_element_entry_values_f eev
1909: set eev.effective_start_date = p_new_date
1910: where eev.element_entry_id = p_element_entry_id
1911: and eev.effective_start_date = p_old_date;
1912: --
1936: ee.updating_action_type = decode(ee.updating_action_type, 'U', 'U', null)
1937: where ee.element_entry_id = p_element_entry_id
1938: and ee.effective_end_date = p_old_date;
1939: --
1940: update pay_element_entry_values_f eev
1941: set eev.effective_end_date = p_new_date
1942: where eev.element_entry_id = p_element_entry_id
1943: and eev.effective_end_date = p_old_date;
1944: --
2527: -- pay_element_entries_f, below, which *always* occurs.
2528: --
2529: l_ee_eed_out := l_calc_ee_eed;
2530: --
2531: update pay_element_entry_values_f eev
2532: set eev.effective_end_date = l_ee_eed_out
2533: where eev.element_entry_id = l_eeid_out;
2534: --
2535: end if;
2841: where ee.element_entry_id = p_element_entry_id
2842: and ee.effective_start_date >= p_ee_effective_start_date
2843: and ee.effective_end_date <= p_ee_effective_end_date;
2844: /* Bug 14184639 Changes end */
2845: delete from pay_element_entry_values_f eev
2846: where eev.element_entry_id = p_element_entry_id
2847: and eev.effective_start_date >= p_ee_effective_start_date
2848: and eev.effective_end_date <= p_ee_effective_end_date;
2849: --
3001: -- update first piece of REE that crosses eligibility boundary,
3002: -- do not delete as this REE cannot be recreated later,
3003: -- update its EED so that it is a day less than the VSD
3004: --
3005: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev
3006: SET eev.effective_end_date = p_validation_start_date - 1
3007: WHERE eev.element_entry_id = p_element_entry_id
3008: and eev.effective_start_date < p_validation_start_date
3009: -- Change 115.60
3154: -- update piece of REE that crosses eligibility boundary,
3155: -- do not delete as this REE cannot be recreated later,
3156: -- update its EED so that it is a day greater than the VSD
3157: --
3158: UPDATE PAY_ELEMENT_ENTRY_VALUES_F eev
3159: SET eev.effective_start_date = p_validation_end_date + 1
3160: WHERE eev.element_entry_id = p_element_entry_id
3161: -- Change 115.60
3162: -- and eev.effective_start_date < p_validation_end_date
3382: -- Remove orphaned entries and entry values
3383: --
3384: for v_entry in csr_orphaned_entries(p_assignment_id) loop
3385: --
3386: delete from pay_element_entry_values_f eev
3387: where eev.element_entry_id = v_entry.element_entry_id;
3388: --
3389: delete from pay_element_entries_f ee
3390: where ee.element_entry_id = v_entry.element_entry_id;
3707:
3708: If lv_asg_exists = 0 then
3709: /*Bug 9710104 If assignment doesnt exists delete the entries */
3710:
3711: delete from pay_element_entry_values_f eev
3712: where eev.element_entry_id = v_entry.element_entry_id;
3713: --
3714: delete from pay_element_entries_f ee
3715: where ee.element_entry_id = v_entry.element_entry_id;
3742: end if;
3743: -- end of change 115.116
3744:
3745: --Commented the below code as part of 6809717
3746: /* delete from pay_element_entry_values_f eev
3747: where eev.element_entry_id = v_entry.element_entry_id;
3748: --
3749: delete from pay_element_entries_f ee
3750: where ee.element_entry_id = v_entry.element_entry_id;*/
5736: p_entries_changed);
5737: --
5738: -- Remove element entry values.
5739: --
5740: delete from pay_element_entry_values_f eev
5741: where eev.element_entry_id = v_entry.element_entry_id
5742: and eev.effective_start_date = v_entry.effective_start_date
5743: and eev.effective_end_date = v_entry.effective_end_date;
5744: --
8132: -- NOT end dated by STOP_RECURRING formula result rules
8133:
8134: hr_utility.set_location(l_proc,60);
8135:
8136: update pay_element_entry_values_f
8137: set effective_end_date = l_new_eed
8138: where element_entry_id = r_entry.element_entry_id
8139: and p_old_final_process_date between effective_start_date and effective_end_date;
8140:
8151: if r_entry.effective_end_date > l_new_final_process_date then
8152:
8153: hr_utility.set_location(l_proc,70);
8154:
8155: update pay_element_entry_values_f
8156: set effective_end_date = l_new_eed
8157: where element_entry_id = r_entry.element_entry_id
8158: and p_old_final_process_date between effective_start_date and effective_end_date
8159: and l_new_eed >= effective_start_date;