[Home] [Help]
2349: hr_utility.set_location('hr_entry.derive_default_value', 3);
2350: end if;
2351: begin
2352: -- INDEX hint added following NHS project recommendation
2353: select /*+ INDEX(l, pay_link_input_values_f_n2) */
2354: l.default_value,
2355: l.min_value,
2356: l.max_value
2357: into v_default_value,
2356: l.max_value
2357: into v_default_value,
2358: v_minimum_value,
2359: v_maximum_value
2360: from pay_link_input_values_f l
2361: where l.input_value_id = p_input_value_id
2362: and l.element_link_id = p_element_link_id
2363: and p_session_date
2364: between l.effective_start_date and l.effective_end_date;
2384: select decode(l.default_value,
2385: '',i.default_value,
2386: l.default_value)
2387: into v_default_value
2388: from pay_link_input_values_f l,
2389: pay_input_values_f i
2390: where i.input_value_id = p_input_value_id
2391: and l.input_value_id = i.input_value_id
2392: and l.element_link_id = p_element_link_id
2591: end if;
2592: begin
2593: select nvl(l.default_value,i.default_value)
2594: into v_default_value
2595: from pay_link_input_values_f l,
2596: pay_input_values_f i
2597: where i.input_value_id = p_input_value_id
2598: and l.input_value_id = i.input_value_id
2599: and l.element_link_id = p_element_link_id
5038: -- Dave Harris, 13-Oct-1994
5039: -- Bug G1420: restricted pay_element_types_f using date effective dates.
5040: --
5041: -- INDEX hint added following NHS project recommendation
5042: select /*+ INDEX(liv, pay_link_input_values_f_n2) */
5043: iv.uom,
5044: iv.hot_default_flag,
5045: et.input_currency_code,
5046: decode(iv.hot_default_flag,
5060: v_input_currency_code,
5061: v_minimum_value,
5062: v_maximum_value,
5063: v_warning_or_error
5064: from pay_link_input_values_f liv,
5065: pay_input_values_f iv,
5066: pay_element_types_f et
5067: where liv.element_link_id = p_element_link_id
5068: and liv.input_value_id = p_input_value_id