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 1224: update hr_s_element_type_rules

1220: update hr_s_element_types_f
1221: set retro_summ_ele_id = l_new_element_type_id
1222: where retro_summ_ele_id = r_distinct.c_surrogate_key;
1223:
1224: update hr_s_element_type_rules
1225: set element_type_id = l_new_element_type_id
1226: where element_type_id = r_distinct.c_surrogate_key;
1227:
1228: update hr_s_formula_result_rules_f

Line 2698: from hr_s_element_type_rules

2694: IS
2695: -- Cursor to install child element type rules
2696:
2697: select *
2698: from hr_s_element_type_rules
2699: where element_set_id = ele_set_id;
2700:
2701: CURSOR child_class(ele_set_id number)
2702: IS

Line 2760: update /*+NO_INDEX*/ hr_s_element_type_rules

2756:
2757: update /*+NO_INDEX*/ hr_s_element_sets
2758: set element_set_id = element_set_id - 50000000;
2759:
2760: update /*+NO_INDEX*/ hr_s_element_type_rules
2761: set element_set_id = element_set_id - 50000000;
2762:
2763: update /*+NO_INDEX*/ hr_s_ele_classn_rules
2764: set element_set_id = element_set_id - 50000000;

Line 2870: update hr_s_element_type_rules

2866: set key_value = to_char(l_new_surrogate_key)
2867: where key_value = to_char(stu_rec.c_surrogate_key)
2868: and key_name = 'ELEMENT_SET_ID';
2869:
2870: update hr_s_element_type_rules
2871: set element_set_id = l_new_surrogate_key
2872: where element_set_id = stu_rec.c_surrogate_key;
2873:
2874: update hr_s_ele_classn_rules

Line 2889: delete from hr_s_element_type_rules

2885: v_number number;
2886:
2887: BEGIN
2888:
2889: delete from hr_s_element_type_rules
2890: where element_set_id = l_new_surrogate_key;
2891:
2892: delete from hr_s_ele_classn_rules
2893: where element_set_id = l_new_surrogate_key;