APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_INPUT_VALUES_F

Line 409: FROM pay_input_values_f

405: -- Cursor to get input value id
406: CURSOR csr_get_iv_id
407: IS
408: SELECT input_value_id
409: FROM pay_input_values_f
410: WHERE element_type_id = p_element_type_id
411: AND NAME = p_input_value_name
412: AND p_effective_date BETWEEN effective_start_date
413: AND effective_end_date;

Line 2672: l_input_value_name pay_input_values_f.NAME%TYPE;

2668: --
2669: l_proc_name VARCHAR2(80)
2670: := g_proc_name || 'set_earnings_history_globals';
2671: l_proc_step PLS_INTEGER;
2672: l_input_value_name pay_input_values_f.NAME%TYPE;
2673: l_input_value_id NUMBER;
2674: l_element_type_id NUMBER;
2675: l_tab_config_values pqp_utilities.t_config_values;
2676: i NUMBER;