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 2706: from hr_s_ele_classn_rules

2702: IS
2703: -- Cursor to install child element classification rules
2704:
2705: select *
2706: from hr_s_ele_classn_rules
2707: where element_set_id = ele_set_id;
2708:
2709: stu_rec stu%ROWTYPE;
2710:

Line 2763: update /*+NO_INDEX*/ hr_s_ele_classn_rules

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;
2765:
2766: update hr_s_application_ownerships
2767: set key_value = key_value - 50000000

Line 2874: update hr_s_ele_classn_rules

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
2875: set element_set_id = l_new_surrogate_key
2876: where element_set_id = stu_rec.c_surrogate_key;
2877:
2878: END update_uid;

Line 2892: delete from hr_s_ele_classn_rules

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;
2894:
2895: delete from hr_s_element_sets
2896: where rowid = stu_rec.rowid;