APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_FORMULA_RESULT_RULES_F

Line 774: from hr_s_formula_result_rules_f

770: IS
771: -- Retrieves formula result rules for a given status processing rule
772:
773: select *
774: from hr_s_formula_result_rules_f
775: where status_processing_rule_id = pc_stat_rule_id;
776:
777: CURSOR d_frrs(pc_stat_rule_id number)
778: IS

Line 783: from hr_s_formula_result_rules_f

779: -- Retrieves distinct id's from formula result rules for a given status
780: -- processing rule.
781:
782: select distinct formula_result_rule_id
783: from hr_s_formula_result_rules_f
784: where status_processing_rule_id = pc_stat_rule_id;
785:
786: CURSOR inputs(pc_element_id number)
787: IS

Line 857: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F

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;
859:
860: update /*+NO_INDEX*/ hr_s_INPUT_VALUES_F
861: set element_type_id = element_type_id - 50000000;

Line 899: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F

895:
896: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
897: set input_value_id = input_value_id - 50000000;
898:
899: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F
900: set input_value_id = input_value_id - 50000000;
901:
902: update /*+NO_INDEX*/ hr_s_balance_types
903: set input_value_id = input_value_id - 50000000;

Line 932: update hr_s_FORMULA_RESULT_RULES_F

928:
929: --conflict may exist
930: --update all status_processing_rule_id's to remove conflict
931:
932: update hr_s_FORMULA_RESULT_RULES_F
933: set status_processing_rule_id=status_processing_rule_id-50000000;
934:
935: update hr_s_STATUS_PROCESSING_RULES_F
936: set status_processing_rule_id=status_processing_rule_id-50000000;

Line 951: from hr_s_formula_result_rules_f b

947: into l_null_return
948: from pay_formula_result_rules_f a
949: where exists
950: (select null
951: from hr_s_formula_result_rules_f b
952: where a.formula_result_rule_id = b.formula_result_rule_id
953: );
954:
955: --conflict may exist

Line 958: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F

954:
955: --conflict may exist
956: --update all formula_result_rule_id's to remove conflict
957:
958: update /*+NO_INDEX*/ hr_s_FORMULA_RESULT_RULES_F
959: set formula_result_rule_id = formula_result_rule_id - 50000000;
960:
961: EXCEPTION WHEN NO_DATA_FOUND THEN NULL;
962:

Line 1062: from hr_s_formula_result_rules_f;

1058: select min(formula_result_rule_id) - (count(*) *3)
1059: , max(formula_result_rule_id) + (count(*) *3)
1060: into v_min_delivered
1061: , v_max_delivered
1062: from hr_s_formula_result_rules_f;
1063:
1064: select pay_formula_result_rules_s.nextval
1065: into v_sequence_number
1066: from dual;

Line 1149: delete from hr_s_formula_result_rules_f a

1145:
1146: delete from hr_s_input_values_f
1147: where element_type_id = v_id;
1148:
1149: delete from hr_s_formula_result_rules_f a
1150: where exists
1151: (select null
1152: from hr_s_status_processing_rules_f b
1153: where b.status_processing_rule_id = a.status_processing_rule_id

Line 1228: update hr_s_formula_result_rules_f

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

Line 1290: update hr_s_formula_result_rules_f

1286: set input_value_id = v_new_input_id,
1287: new_input_value_flag = v_new_input_value_flag
1288: where input_value_id = i_vals.input_value_id;
1289:
1290: update hr_s_formula_result_rules_f
1291: set input_value_id = v_new_input_id
1292: where input_value_id = i_vals.input_value_id;
1293:
1294: update hr_s_balance_types

Line 1421: update hr_s_formula_result_rules_f

1417: select pay_formula_Result_rules_s.nextval
1418: into v_new_frr_id
1419: from dual;
1420:
1421: update hr_s_formula_result_rules_f
1422: set formula_result_rule_id = v_new_frr_id
1423: , status_processing_rule_id = v_new_spr_id
1424: where formula_result_rule_id = results.formula_result_rule_id;
1425: