87: AND c_effective_date BETWEEN pev.effective_start_date AND pev.effective_end_date
88: AND pev.input_value_id = p_inp_val;
89:
90:
91: l_inp_value_id_table hr_entry.number_table;
92: l_scr_value_table hr_entry.varchar2_table;
93:
94: l_dummy NUMBER;
95: l_element_type_id NUMBER;
88: AND pev.input_value_id = p_inp_val;
89:
90:
91: l_inp_value_id_table hr_entry.number_table;
92: l_scr_value_table hr_entry.varchar2_table;
93:
94: l_dummy NUMBER;
95: l_element_type_id NUMBER;
96: l_element_link_id NUMBER;
169:
170: --
171: -- Get the element link id for the PAYE information element
172: --
173: l_element_link_id := hr_entry_api.get_link
174: (p_assignment_id => p_assignment_id
175: ,p_element_type_id => l_element_type_id
176: ,p_session_date => l_effective_date);
177: