APPS.PAY_US_EARNINGS_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 152: FROM pay_input_values_f

148:
149: CURSOR c_inp_val(p_input_val_name IN VARCHAR2,
150: p_element_type_id IN NUMBER) IS
151: SELECT input_value_id
152: FROM pay_input_values_f
153: WHERE element_type_id = p_element_type_id
154: AND upper(NAME) = upper(p_input_val_name);
155:
156: CURSOR c_pspr(p_element_type_id IN NUMBER,

Line 539: UPDATE pay_input_values_f

535: t_def_val(2) := p_sep_check_option;
536: --
537: hr_utility.set_location(l_proc, 170);
538: FOR i in 1..2 LOOP
539: UPDATE pay_input_values_f
540: SET formula_id = t_form_id(i)
541: ,warning_or_error = t_we_flag(i)
542: ,default_value = t_def_val(i)
543: WHERE input_value_id = t_ipv_id(i);

Line 667: FROM pay_input_values_f piv

663: AND business_group_id = g_bg_id;
664: --
665: CURSOR c_get_ipv_id IS -- Gets the input value id
666: SELECT piv.input_value_id
667: FROM pay_input_values_f piv
668: WHERE piv.NAME = p_object_name
669: AND piv.element_type_id = p_object_id
670: AND piv.business_group_id = g_bg_id;
671: --