23: SELECT *
24: FROM (SELECT iv_data.*, ROWNUM r
25: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
26: etp.input_currency_code
27: FROM pay_input_values_f inv,
28: pay_element_types_f etp
29: WHERE inv.element_type_id = p_element_type_id
30: AND etp.element_type_id = p_element_type_id
31: AND p_session_date
95: SELECT *
96: FROM (SELECT iv_data.*, ROWNUM r
97: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
98: etp.input_currency_code
99: FROM pay_input_values_f inv,
100: pay_element_types_f etp
101: WHERE inv.element_type_id = p_element_type_id
102: AND etp.element_type_id = p_element_type_id
103: AND p_session_date