23: cursor set_of_input_values is
24: --
25: select input_value_tl.name
26: --
27: from pay_input_values_f_tl INPUT_VALUE_TL,
28: pay_input_values_f INPUT_VALUE
29: --
30: where input_value.element_type_id = p_element_type_id
31: and input_value_tl.input_value_id = input_value.input_value_id
24: --
25: select input_value_tl.name
26: --
27: from pay_input_values_f_tl INPUT_VALUE_TL,
28: pay_input_values_f INPUT_VALUE
29: --
30: where input_value.element_type_id = p_element_type_id
31: and input_value_tl.input_value_id = input_value.input_value_id
32: and userenv('LANG') = input_value_tl.language
145: cursor set_of_input_values is
146: --
147: select input_value_tl.name
148: --
149: from pay_input_values_f_tl INPUT_VALUE_TL,
150: pay_input_values_f INPUT_VALUE
151: --
152: where input_value.element_type_id = p_element_type_id
153: and input_value_tl.input_value_id = input_value.input_value_id
146: --
147: select input_value_tl.name
148: --
149: from pay_input_values_f_tl INPUT_VALUE_TL,
150: pay_input_values_f INPUT_VALUE
151: --
152: where input_value.element_type_id = p_element_type_id
153: and input_value_tl.input_value_id = input_value.input_value_id
154: and userenv('LANG') = input_value_tl.language
234: , TYPE.value_set_id
235: , nvl (b.default_value, TYPE.default_value) hot_default_value
236: FROM (
237: SELECT *
238: FROM pay_input_values_f piv
239: , pay_element_links_f pil
240: WHERE pil.element_type_id = piv.element_type_id
241: AND pil.element_link_id = p_element_link_id
242: and piv.effective_start_date =
783: , TYPE.value_set_id
784: , nvl (b.default_value, TYPE.default_value) hot_default_value
785: FROM (
786: SELECT *
787: FROM pay_input_values_f piv
788: , pay_element_links_f pil
789: WHERE pil.element_type_id = piv.element_type_id
790: AND pil.element_link_id = p_element_link_id
791: and piv.effective_start_date =