APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PAY_INPUT_VALUES_F

Line 224: FROM pay_input_values_f

220: -- Cursor to get input value id
221: CURSOR csr_get_iv_id
222: IS
223: SELECT input_value_id
224: FROM pay_input_values_f
225: WHERE element_type_id = p_element_type_id
226: AND NAME = p_input_value_name
227: AND p_effective_date BETWEEN effective_start_date
228: AND effective_end_date;

Line 2430: l_input_value_name pay_input_values_f.NAME%TYPE;

2426: --
2427: l_proc_name VARCHAR2(80)
2428: := g_proc_name || 'set_service_history_globals';
2429: l_proc_step PLS_INTEGER;
2430: l_input_value_name pay_input_values_f.NAME%TYPE;
2431: l_input_value_id NUMBER;
2432: l_element_type_id NUMBER;
2433: l_tab_config_values pqp_utilities.t_config_values;
2434: i NUMBER;