243: pay_element_entry_values_f eev4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
244: pay_element_entry_values_f eev5 ,
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
252: hr_lookups hrl5
245: pay_element_entry_values_f eev6 ,
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
252: hr_lookups hrl5
253: WHERE pee.element_entry_id = p_element_entry_id
246: pay_element_entry_values_f eev7 ,
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
252: hr_lookups hrl5
253: WHERE pee.element_entry_id = p_element_entry_id
254: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
247: hr_lookups hrl0 ,
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
252: hr_lookups hrl5
253: WHERE pee.element_entry_id = p_element_entry_id
254: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
255: AND eev0.ELEMENT_ENTRY_ID = pee.element_entry_id
248: hr_lookups hrl1 ,
249: hr_lookups hrl2 ,
250: hr_lookups hrl3 ,
251: hr_lookups hrl4 ,
252: hr_lookups hrl5
253: WHERE pee.element_entry_id = p_element_entry_id
254: AND eev0.INPUT_VALUE_ID = p_au_res_input_value_id
255: AND eev0.ELEMENT_ENTRY_ID = pee.element_entry_id
256: AND hrl0.lookup_type (+) = 'AU_AUST_RES_SENR_AUS'