APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELEMENT_TYPE_RULES

Line 854: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPE_RULES

850: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPES_F
851: set element_type_id = element_type_id - 50000000,
852: retro_summ_ele_id = retro_summ_ele_id - 50000000;
853:
854: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPE_RULES
855: set element_type_id = element_type_id - 50000000;
856:
857: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F
858: set element_type_id = element_type_id - 50000000;

Line 1237: update hr_s_element_type_rules

1233: update hr_s_element_types_f
1234: set retro_summ_ele_id = l_new_element_type_id
1235: where retro_summ_ele_id = r_distinct.c_surrogate_key;
1236:
1237: update hr_s_element_type_rules
1238: set element_type_id = l_new_element_type_id
1239: where element_type_id = r_distinct.c_surrogate_key;
1240:
1241: update hr_s_formula_result_rules_f

Line 2730: from hr_s_element_type_rules

2726: IS
2727: -- Cursor to install child element type rules
2728:
2729: select *
2730: from hr_s_element_type_rules
2731: where element_set_id = ele_set_id;
2732:
2733: CURSOR child_class(ele_set_id number)
2734: IS

Line 2792: update /*+NO_INDEX*/ hr_s_element_type_rules

2788:
2789: update /*+NO_INDEX*/ hr_s_element_sets
2790: set element_set_id = element_set_id - 50000000;
2791:
2792: update /*+NO_INDEX*/ hr_s_element_type_rules
2793: set element_set_id = element_set_id - 50000000;
2794:
2795: update /*+NO_INDEX*/ hr_s_ele_classn_rules
2796: set element_set_id = element_set_id - 50000000;

Line 2902: update hr_s_element_type_rules

2898: set key_value = to_char(l_new_surrogate_key)
2899: where key_value = to_char(stu_rec.c_surrogate_key)
2900: and key_name = 'ELEMENT_SET_ID';
2901:
2902: update hr_s_element_type_rules
2903: set element_set_id = l_new_surrogate_key
2904: where element_set_id = stu_rec.c_surrogate_key;
2905:
2906: update hr_s_ele_classn_rules

Line 2921: delete from hr_s_element_type_rules

2917: v_number number;
2918:
2919: BEGIN
2920:
2921: delete from hr_s_element_type_rules
2922: where element_set_id = l_new_surrogate_key;
2923:
2924: delete from hr_s_ele_classn_rules
2925: where element_set_id = l_new_surrogate_key;