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 1241: update hr_s_formula_result_rules_f

1237: update hr_s_element_type_rules
1238: set element_type_id = l_new_element_type_id
1239: where element_type_id = r_distinct.c_surrogate_key;
1240:
1241: update hr_s_formula_result_rules_f
1242: set element_type_id = l_new_element_type_id
1243: where element_type_id = r_distinct.c_surrogate_key;
1244:
1245: update hr_s_application_ownerships

Line 1311: update hr_s_formula_result_rules_f

1307: set input_value_id = v_new_input_id,
1308: new_input_value_flag = v_new_input_value_flag
1309: where input_value_id = i_vals.input_value_id;
1310:
1311: update hr_s_formula_result_rules_f
1312: set input_value_id = v_new_input_id
1313: where input_value_id = i_vals.input_value_id;
1314:
1315: update hr_s_balance_types

Line 1442: update hr_s_formula_result_rules_f

1438: select pay_formula_Result_rules_s.nextval
1439: into v_new_frr_id
1440: from dual;
1441:
1442: update hr_s_formula_result_rules_f
1443: set formula_result_rule_id = v_new_frr_id
1444: , status_processing_rule_id = v_new_spr_id
1445: where formula_result_rule_id = results.formula_result_rule_id;
1446: