APPS.NTG_EARNINGS_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 90: FROM pay_input_values_f

86: -- Cursor to get Input value to set iterative processing rule.
87: --
88: CURSOR c_input_value_id IS
89: SELECT input_value_id, name
90: FROM pay_input_values_f
91: WHERE element_type_id = l_pri_ele_type_id;
92: --
93: --=======================================================================
94: -- FUNCTION GET_OBJ_ID

Line 112: FROM pay_input_values_f piv

108: AND business_group_id+0 = p_bg_id;
109: --
110: CURSOR c_get_ipv_id IS -- Gets the input value id
111: SELECT piv.input_value_id
112: FROM pay_input_values_f piv
113: WHERE piv.name = p_object_name
114: AND piv.element_type_id = p_object_id
115: AND piv.business_group_id + 0 = p_bg_id;
116: --

Line 426: UPDATE pay_input_values_f

422: t_def_val(1) := p_sep_check_option;
423:
424: hr_utility.set_location('Leaving: '||l_proc, 170);
425: FOR i in 1..1 LOOP
426: UPDATE pay_input_values_f
427: SET formula_id = t_form_id(i)
428: ,warning_or_error = t_we_flag(i)
429: ,default_value = t_def_val(i)
430: WHERE input_value_id = t_ipv_id(i);

Line 453: from pay_input_values_f

449:
450: hr_utility.set_location('element type id' || l_seeded_ele_type_id , 137);
451: Select input_value_id
452: into l_seeded_input_val_id
453: from pay_input_values_f
454: where element_type_id = l_seeded_ele_type_id
455: and upper(name) = 'AMOUNT';
456:
457: select pay_formula_result_rules_s.nextval