259: pay_element_entry_values_f eev5 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
260: pay_element_entry_values_f eev6 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
261: pay_element_entry_values_f eev7 ,
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
269: hr_lookups hr16
262: pay_element_entry_values_f eev8 ,
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
269: hr_lookups hr16
270: WHERE pee.element_entry_id = p_element_entry_id
263: hr_lookups hrl0 ,
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
269: hr_lookups hr16
270: WHERE pee.element_entry_id = p_element_entry_id
271: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
264: hr_lookups hrl1 ,
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
269: hr_lookups hr16
270: WHERE pee.element_entry_id = p_element_entry_id
271: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
272: AND eev0.ELEMENT_ENTRY_ID = pee.element_entry_id
265: hr_lookups hrl2 ,
266: hr_lookups hrl3 ,
267: hr_lookups hrl4 ,
268: hr_lookups hrl5 ,
269: hr_lookups hr16
270: WHERE pee.element_entry_id = p_element_entry_id
271: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
272: AND eev0.ELEMENT_ENTRY_ID = pee.element_entry_id
273: AND hrl0.lookup_type (+) = 'AU_AUST_RES_SENR_AUS'