APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on PAY_FORMULA_RESULT_RULES_F

Line 192: result_name pay_formula_result_rules_f.result_name%type,

188: l_effective_start_date date;
189: l_effective_end_date date;
190: TYPE input_value_rec IS RECORD
191: ( input_value_id pay_input_values_f.input_value_id%type,
192: result_name pay_formula_result_rules_f.result_name%type,
193: result_rule_type pay_formula_result_rules_f.result_rule_type%type,
194: uom pay_input_values_f.uom%type,
195: base_name pay_input_values_f.name%type,
196: meaning_iv_name pay_input_values_f.name%type);

Line 193: result_rule_type pay_formula_result_rules_f.result_rule_type%type,

189: l_effective_end_date date;
190: TYPE input_value_rec IS RECORD
191: ( input_value_id pay_input_values_f.input_value_id%type,
192: result_name pay_formula_result_rules_f.result_name%type,
193: result_rule_type pay_formula_result_rules_f.result_rule_type%type,
194: uom pay_input_values_f.uom%type,
195: base_name pay_input_values_f.name%type,
196: meaning_iv_name pay_input_values_f.name%type);
197:

Line 433: update pay_formula_result_rules_f

429: p_element_type_id => l_element_id);
430: IF l_index in (2,3,4) then
431: /* As direct input value for direct results always gets set to Pay value, we need to
432: update the result rule to have the correct input value id */
433: update pay_formula_result_rules_f
434: set input_value_id = l_input_value(l_index).input_value_id
435: where formula_result_rule_id = l_fres_rule_id;
436: END IF;
437: End loop;