APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_INPUT_VALUES_F

Line 794: from hr_s_input_values_f

790: select distinct input_value_id
791: , name
792: , value_set_name
793: , new_input_value_flag
794: from hr_s_input_values_f
795: where element_Type_id = pc_element_id;
796:
797: -- These records are defined here so all sub procedures may use the
798: -- values selected. This saves the need for all sub procedures to have

Line 860: update /*+NO_INDEX*/ hr_s_INPUT_VALUES_F

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;
862:
863: update /*+NO_INDEX*/ hr_s_STATUS_PROCESSING_RULES_F
864: set element_type_id = element_type_id - 50000000;

Line 886: from hr_s_input_values_f b

882: into l_null_return
883: from pay_input_values_f a
884: where exists
885: (select null
886: from hr_s_input_values_f b
887: where a.input_value_id = b.input_value_id
888: );
889:
890: --conflict may exist

Line 893: update /*+NO_INDEX*/ hr_s_INPUT_VALUES_F

889:
890: --conflict may exist
891: --update all input_value_id's to remove conflict
892:
893: update /*+NO_INDEX*/ hr_s_INPUT_VALUES_F
894: set input_value_id = input_value_id - 50000000;
895:
896: update /*+NO_INDEX*/ hr_s_BALANCE_FEEDS_F
897: set input_value_id = input_value_id - 50000000;

Line 1018: from hr_s_input_values_f;

1014: select min(input_value_id) - (count(*) *3)
1015: , max(input_value_id) + (count(*) *3)
1016: into v_min_delivered
1017: , v_max_delivered
1018: from hr_s_input_values_f;
1019:
1020: select pay_input_Values_s.nextval
1021: into v_sequence_number
1022: from dual;

Line 1146: delete from hr_s_input_values_f

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;
1148:
1149: delete from hr_s_formula_result_rules_f a
1150: where exists

Line 1279: update hr_s_input_values_f

1275: hr_legislation.hrrunprc_trace_off;
1276: raise;
1277: END;
1278:
1279: update hr_s_input_values_f
1280: set input_value_id = v_new_input_id
1281: , element_type_id = l_new_element_type_id
1282: , new_input_value_flag = v_new_input_value_flag
1283: where input_value_id = i_vals.input_value_id;

Line 2026: -- to populate the HR_S_INPUT_VALUES_F.VALUE_SET_ID col with

2022:
2023: BEGIN
2024:
2025: -- Get the correct value set id from FND_FLEX_VALUES_SETS
2026: -- to populate the HR_S_INPUT_VALUES_F.VALUE_SET_ID col with
2027:
2028: select FLEX_VALUE_SET_ID
2029: into l_flex_value_set_id
2030: from fnd_flex_value_sets

Line 2092: from hr_s_input_values_f

2088: ,last_update_login
2089: ,created_by
2090: ,creation_date
2091: ,l_flex_value_set_id
2092: from hr_s_input_values_f
2093: where input_value_id = i_values.input_value_id;
2094: EXCEPTION WHEN OTHERS THEN
2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');

Line 2105: delete from hr_s_input_values_f

2101: hr_legislation.hrrunprc_trace_off;
2102: raise;
2103: END;
2104:
2105: delete from hr_s_input_values_f
2106: where input_value_id = i_values.input_value_id;
2107: --
2108: -- Bug 2888183 - need to insert balance feeds
2109: --

Line 2132: from hr_s_input_values_f

2128: -- If any input values remain, indicate to calling proc
2129:
2130: select distinct null
2131: into l_null_Return
2132: from hr_s_input_values_f
2133: where element_type_id = l_new_element_type_id;
2134:
2135: END IF;
2136: