[Home] [Help]
2600: hr_utility.set_location('hr_entry.derive_default_value', 3);
2601: end if;
2602: begin
2603: -- INDEX hint added following NHS project recommendation
2604: select /*+ INDEX(l, pay_link_input_values_f_n2) */
2605: l.default_value,
2606: l.min_value,
2607: l.max_value
2608: into v_default_value,
2607: l.max_value
2608: into v_default_value,
2609: v_minimum_value,
2610: v_maximum_value
2611: from pay_link_input_values_f l
2612: where l.input_value_id = p_input_value_id
2613: and l.element_link_id = p_element_link_id
2614: and p_session_date
2615: between l.effective_start_date and l.effective_end_date;
2635: select decode(l.default_value,
2636: '',i.default_value,
2637: l.default_value)
2638: into v_default_value
2639: from pay_link_input_values_f l,
2640: pay_input_values_f i
2641: where i.input_value_id = p_input_value_id
2642: and l.input_value_id = i.input_value_id
2643: and l.element_link_id = p_element_link_id
2842: end if;
2843: begin
2844: select nvl(l.default_value,i.default_value)
2845: into v_default_value
2846: from pay_link_input_values_f l,
2847: pay_input_values_f i
2848: where i.input_value_id = p_input_value_id
2849: and l.input_value_id = i.input_value_id
2850: and l.element_link_id = p_element_link_id
5421: -- Dave Harris, 13-Oct-1994
5422: -- Bug G1420: restricted pay_element_types_f using date effective dates.
5423: --
5424: -- INDEX hint added following NHS project recommendation
5425: select /*+ INDEX(liv, pay_link_input_values_f_n2) */
5426: iv.uom,
5427: iv.hot_default_flag,
5428: et.input_currency_code,
5429: decode(iv.hot_default_flag,
5443: v_input_currency_code,
5444: v_minimum_value,
5445: v_maximum_value,
5446: v_warning_or_error
5447: from pay_link_input_values_f liv,
5448: pay_input_values_f iv,
5449: pay_element_types_f et
5450: where liv.element_link_id = p_element_link_id
5451: and liv.input_value_id = p_input_value_id