378: max(decode(piv.name,'Rate Type',eev1.screen_entry_value)) rt1,
379: max(decode(piv.name,'Rate Type',eev2.screen_entry_value)) rt2
380: from pay_element_entries_f pee1,
381: pay_element_entries_f pee2,
382: pay_entry_process_details epd1,
383: pay_entry_process_details epd2,
384: pay_element_entry_values_f eev1,
385: pay_element_entry_values_f eev2,
386: pay_input_values_f piv
379: max(decode(piv.name,'Rate Type',eev2.screen_entry_value)) rt2
380: from pay_element_entries_f pee1,
381: pay_element_entries_f pee2,
382: pay_entry_process_details epd1,
383: pay_entry_process_details epd2,
384: pay_element_entry_values_f eev1,
385: pay_element_entry_values_f eev2,
386: pay_input_values_f piv
387: where pee1.element_entry_id = p_element_entry_id