APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_ELEMENT_TYPES_F

Line 121: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPES_F

117:
118: update /*+NO_INDEX*/ hr_s_BALANCE_CLASSIFICATIONS
119: set classification_id = classification_id - 50000000;
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;

Line 293: update hr_s_element_types_f

289: set key_value = to_char(l_new_surrogate_key)
290: where key_value = to_char(stu_rec.c_surrogate_key)
291: and key_name = 'CLASSIFICATION_ID';
292:
293: update hr_s_element_types_f
294: set classification_id = l_new_surrogate_key
295: where classification_id = stu_rec.c_surrogate_key;
296:
297: update hr_s_balance_classifications

Line 704: from hr_s_element_types_f;

700: -- guarenteed to be unique. This cursor selects all distinct names
701: -- for the next cusrsor to select distinct element_type_id's from.
702:
703: select distinct element_name
704: from hr_s_element_types_f;
705:
706: CURSOR c_distinct_element(pc_ele_name varchar2)
707: IS
708: -- Retrieve all distinct element type id's for the current element.

Line 718: from hr_s_element_types_f

714: , element_name c_true_key
715: , legislation_code
716: , legislation_subgroup
717: , nvl(new_element_type_flag, 'Y') new_element_type_flag
718: from hr_s_element_types_f
719: where element_name = pc_ele_name
720: group by element_type_id
721: , element_name
722: , legislation_code

Line 735: from hr_s_element_types_f

731: -- This cursor accepts the primary key as a parameter and selects all
732: -- date effective rows for it.
733:
734: select *
735: from hr_s_element_types_f
736: where element_type_id = pc_element_type_id;
737:
738: CURSOR sub_rules(pc_element_id number)
739: IS

Line 843: from hr_s_element_types_f b

839: into l_null_return
840: from pay_element_types_f a
841: where exists
842: (select null
843: from hr_s_element_types_f b
844: where a.element_type_id = b.element_type_id
845: );
846:
847: --conflict may exist

Line 850: update /*+NO_INDEX*/ hr_s_ELEMENT_TYPES_F

846:
847: --conflict may exist
848: --update all element_type_id's to remove conflict
849:
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

Line 994: from hr_s_element_types_f;

990: select min(element_type_id) - (count(*) *3)
991: , max(element_type_id) + (count(*) *3)
992: into v_min_delivered
993: , v_max_delivered
994: from hr_s_element_types_f;
995:
996: select pay_element_types_s.nextval
997: into v_sequence_number
998: from dual;

Line 1140: delete from hr_s_element_types_f

1136: -- application ownership rows
1137:
1138: BEGIN
1139:
1140: delete from hr_s_element_types_f
1141: where element_type_id = v_id;
1142:
1143: delete from hr_s_sub_classn_rules_f
1144: where element_type_id = v_id;

Line 1228: update hr_s_element_types_f

1224: hr_legislation.hrrunprc_trace_off;
1225: raise;
1226: END;
1227:
1228: update hr_s_element_types_f
1229: set element_type_id = l_new_element_type_id,
1230: new_element_type_flag = v_new_element_type_flag
1231: where element_type_id = r_distinct.c_surrogate_key;
1232:

Line 1233: update hr_s_element_types_f

1229: set element_type_id = l_new_element_type_id,
1230: new_element_type_flag = v_new_element_type_flag
1231: where element_type_id = r_distinct.c_surrogate_key;
1232:
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