APPS.PY_FR_ADDITIONAL_ELEMENT_RULES dependencies on PAY_INPUT_VALUES_F

Line 78: update pay_input_values_f

74: -- Bug 3794513, need to use US lang base names for context inputs.
75: -- Nb. This may not match a value in the tl table, but that is also
76: -- true of the Pay Value input.
77: if p_base_name <> p_input_value_name then
78: update pay_input_values_f
79: set name = p_base_name
80: where input_value_id = l_input_value_id;
81: end if;
82: return l_input_value_id;

Line 129: pay_input_values_f piv

125: select *
126: from pay_element_links_f
127: where element_link_id in ( select pel.element_link_id
128: from pay_element_links_f pel,
129: pay_input_values_f piv
130: where pel.element_type_id = piv.element_type_id
131: and piv.input_value_id = p_pto_input_value_id
132: and p_effective_date between pel.effective_start_date
133: and pel.effective_end_date

Line 140: where element_type_id =(select element_type_id from pay_input_values_f

136:
137: cursor class_id is
138: select classification_id
139: from pay_element_types_f
140: where element_type_id =(select element_type_id from pay_input_values_f
141: where input_value_id = p_pto_input_value_id)
142: and rownum = 1;
143:
144: cursor csr_name_translation(p_code varchar2) is

Line 191: ( input_value_id pay_input_values_f.input_value_id%type,

187: l_ovn number;
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,

Line 194: uom pay_input_values_f.uom%type,

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:
198: TYPE t_input_value IS TABLE OF input_value_rec INDEX BY BINARY_INTEGER;

Line 195: base_name pay_input_values_f.name%type,

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:
198: TYPE t_input_value IS TABLE OF input_value_rec INDEX BY BINARY_INTEGER;
199: l_input_value t_input_value;

Line 196: meaning_iv_name pay_input_values_f.name%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:
198: TYPE t_input_value IS TABLE OF input_value_rec INDEX BY BINARY_INTEGER;
199: l_input_value t_input_value;
200:

Line 407: from pay_input_values_f

403:
404: /* Need to select the ip value id for Pay Value as this is created automatically */
405: Select input_value_id
406: into l_input_value(6).input_value_id
407: from pay_input_values_f
408: where element_type_id = l_element_id
409: and name = 'Pay Value';
410:
411: /* Rate input value is target for 2 results so set the dummy rate input_value_id */