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 1300: update hr_s_input_values_f

1296: hr_legislation.hrrunprc_trace_off;
1297: raise;
1298: END;
1299:
1300: update hr_s_input_values_f
1301: set input_value_id = v_new_input_id
1302: , element_type_id = l_new_element_type_id
1303: , new_input_value_flag = v_new_input_value_flag
1304: where input_value_id = i_vals.input_value_id;

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

2054:
2055: BEGIN
2056:
2057: -- Get the correct value set id from FND_FLEX_VALUES_SETS
2058: -- to populate the HR_S_INPUT_VALUES_F.VALUE_SET_ID col with
2059:
2060: select FLEX_VALUE_SET_ID
2061: into l_flex_value_set_id
2062: from fnd_flex_value_sets

Line 2124: from hr_s_input_values_f

2120: ,last_update_login
2121: ,created_by
2122: ,creation_date
2123: ,l_flex_value_set_id
2124: from hr_s_input_values_f
2125: where input_value_id = i_values.input_value_id;
2126: EXCEPTION WHEN OTHERS THEN
2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');

Line 2137: delete from hr_s_input_values_f

2133: hr_legislation.hrrunprc_trace_off;
2134: raise;
2135: END;
2136:
2137: delete from hr_s_input_values_f
2138: where input_value_id = i_values.input_value_id;
2139: --
2140: -- Bug 2888183 - need to insert balance feeds
2141: --

Line 2164: from hr_s_input_values_f

2160: -- If any input values remain, indicate to calling proc
2161:
2162: select distinct null
2163: into l_null_Return
2164: from hr_s_input_values_f
2165: where element_type_id = l_new_element_type_id;
2166:
2167: END IF;
2168: