APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PAY_INPUT_VALUES_F

Line 329: FROM pay_input_values_f

325: -- Cursor to get input value id
326: CURSOR csr_get_iv_id
327: IS
328: SELECT input_value_id
329: FROM pay_input_values_f
330: WHERE element_type_id = p_element_type_id
331: AND NAME = p_input_value_name
332: AND p_effective_date BETWEEN effective_start_date
333: AND effective_end_date;

Line 2516: l_input_value_name pay_input_values_f.NAME%TYPE;

2512: --
2513: l_proc_name VARCHAR2(80)
2514: := g_proc_name || 'set_earnings_history_globals';
2515: l_proc_step PLS_INTEGER;
2516: l_input_value_name pay_input_values_f.NAME%TYPE;
2517: l_input_value_id NUMBER;
2518: l_element_type_id NUMBER;
2519: l_tab_config_values pqp_utilities.t_config_values;
2520: i NUMBER;