2: /* $Header: pypprdpm.pkb 115.10 2004/02/25 21:48:19 adkumar noship $ */
3:
4: ------------------------------ user_key_to_id ---------------------------------
5: --
6: -- Returns an ID value from hr_pump_batch_line_user_keys alone.
7: -- Utility function to get _ID functions.
8: --
9: Function user_key_to_id(p_user_key_value in varchar2)
10: return number is
11: l_id number;
12: Begin
13: select unique_key_id
14: into l_id
15: from hr_pump_batch_line_user_keys
16: where user_key_value = p_user_key_value;
17: return(l_id);
18: End user_key_to_id;
19: --
191: Begin
192: select spr.object_version_number
193: into l_spr_ovn
194: from pay_status_processing_rules_f spr,
195: hr_pump_batch_line_user_keys key
196: where key.user_key_value = p_status_process_rule_user_key
197: and spr.status_processing_rule_id = key.unique_key_id
198: and p_effective_date between spr.effective_start_date
199: and spr.effective_end_date;