APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELE_CLASSN_RULES

Line 124: update /*+NO_INDEX*/ hr_s_ELE_CLASSN_RULES

120:
121: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPES_F
122: set classification_id = classification_id - 50000000;
123:
124: update /*+NO_INDEX*/ hr_s_ELE_CLASSN_RULES
125: set classification_id = classification_id - 50000000;
126:
127: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F
128: set classification_id = classification_id - 50000000;

Line 305: update hr_s_ele_classn_rules

301: update hr_s_sub_classn_rules_f
302: set classification_id = l_new_surrogate_key
303: where classification_id = stu_rec.c_surrogate_key;
304:
305: update hr_s_ele_classn_rules
306: set classification_id = l_new_surrogate_key
307: where classification_id = stu_rec.c_surrogate_key;
308:
309: update hr_s_taxability_rules

Line 2738: from hr_s_ele_classn_rules

2734: IS
2735: -- Cursor to install child element classification rules
2736:
2737: select *
2738: from hr_s_ele_classn_rules
2739: where element_set_id = ele_set_id;
2740:
2741: stu_rec stu%ROWTYPE;
2742:

Line 2795: update /*+NO_INDEX*/ hr_s_ele_classn_rules

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;
2797:
2798: update hr_s_application_ownerships
2799: set key_value = key_value - 50000000

Line 2906: update hr_s_ele_classn_rules

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
2907: set element_set_id = l_new_surrogate_key
2908: where element_set_id = stu_rec.c_surrogate_key;
2909:
2910: END update_uid;

Line 2924: delete from hr_s_ele_classn_rules

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;
2926:
2927: delete from hr_s_element_sets
2928: where rowid = stu_rec.rowid;