APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_SUB_CLASSN_RULES_F

Line 127: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F

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;
129:
130: --
131: -- #346359 ensure STU_TAXABILITY_RULES classification_id is kept

Line 301: update hr_s_sub_classn_rules_f

297: update hr_s_balance_classifications
298: set classification_id = l_new_surrogate_key
299: where classification_id = stu_rec.c_surrogate_key;
300:
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

Line 743: from hr_s_sub_classn_rules_f

739: IS
740: -- Retrieves sub classification rules for the current element
741:
742: select *
743: from hr_s_sub_classn_rules_f
744: where element_type_id = pc_element_id;
745:
746: CURSOR proc_rules(pc_element_id number)
747: IS

Line 866: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F

862:
863: update /*+NO_INDEX*/ hr_s_STATUS_PROCESSING_RULES_F
864: set element_type_id = element_type_id - 50000000;
865:
866: update /*+NO_INDEX*/ hr_s_SUB_CLASSN_RULES_F
867: set element_type_id = element_type_id - 50000000;
868:
869: update hr_s_application_ownerships
870: set key_value = key_value - 50000000

Line 974: from hr_s_sub_classn_rules_f b

970: into l_null_return
971: from pay_sub_classification_rules_f a
972: where exists
973: (select null
974: from hr_s_sub_classn_rules_f b
975: where a.sub_classification_rule_id=b.sub_classification_rule_id
976: );
977:
978: --conflict may exist

Line 981: update /*+NO_INDEX*/ hr_s_sub_classn_rules_f

977:
978: --conflict may exist
979: --update all sub_classification_rule_id's to remove conflict
980:
981: update /*+NO_INDEX*/ hr_s_sub_classn_rules_f
982: set sub_classification_rule_id=sub_classification_rule_id-50000000;
983:
984: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
985:

Line 1085: from hr_s_sub_classn_rules_f;

1081: select min(sub_classification_rule_id) - (count(*) *3)
1082: , max(sub_classification_rule_id) + (count(*) *3)
1083: into v_min_delivered
1084: , v_max_delivered
1085: from hr_s_sub_classn_rules_f;
1086:
1087: select pay_sub_classification_rules_s.nextval
1088: into v_sequence_number
1089: from dual;

Line 1143: delete from hr_s_sub_classn_rules_f

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;
1145:
1146: delete from hr_s_input_values_f
1147: where element_type_id = v_id;

Line 1329: update hr_s_sub_classn_rules_f

1325: select pay_sub_classification_rules_s.nextval
1326: into v_new_sub_class_id
1327: from dual;
1328:
1329: update hr_s_sub_classn_rules_f
1330: set sub_classification_rule_id = v_new_sub_class_id
1331: , element_type_id = l_new_element_type_id
1332: where sub_classification_rule_id = s_class.sub_classification_rule_id;
1333:

Line 1338: from hr_s_sub_classn_rules_f hscr

1334: BEGIN
1335:
1336: select sub_classification_rule_id
1337: into v_dummy
1338: from hr_s_sub_classn_rules_f hscr
1339: where hscr.sub_classification_rule_id = v_new_sub_class_id
1340: and exists
1341: ( select 1
1342: from pay_sub_classification_rules_f pscr

Line 1358: update hr_s_sub_classn_rules_f

1354: v_new_sub_class_rule_flag := 'Y';
1355:
1356: END;
1357:
1358: update hr_s_sub_classn_rules_f
1359: set new_sub_class_rule_flag = v_new_sub_class_rule_flag
1360: where sub_classification_rule_id = s_class.sub_classification_rule_id;
1361:
1362: END LOOP s_class;