[Home] [Help]
2: /* $Header: pyeledpm.pkb 120.0 2005/05/29 04:31:38 appldev 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: --
88: Begin
89: select pel.object_version_number
90: into l_element_link_ovn
91: from pay_element_links_f pel,
92: hr_pump_batch_line_user_keys key
93: where key.user_key_value = p_element_link_user_key
94: and pel.element_link_id = key.unique_key_id
95: and p_effective_date between
96: pel.effective_start_date and pel.effective_end_date;
132: --
133: select liv.link_input_value_id
134: into l_link_input_value_id
135: from pay_link_input_values_f liv,
136: hr_pump_batch_line_user_keys key
137: where key.user_key_value = p_element_link_user_key
138: and liv.element_link_id = key.unique_key_id
139: and liv.input_value_id = l_input_value_id
140: and p_effective_date between liv.effective_start_date
474: Begin
475: Select pet.object_version_number
476: into l_element_type_ovn
477: From pay_element_types_f pet,
478: hr_pump_batch_line_user_keys key
479: Where key.user_key_value = p_element_type_user_key
480: and pet.element_type_id = key.unique_key_id
481: and p_effective_date between
482: pet.effective_start_date and pet.effective_end_date;
602: select pettl.element_name
603: into l_element_name
604: from pay_element_types_f pet,
605: pay_element_types_f_tl pettl,
606: hr_pump_batch_line_user_keys
607: where pettl.language = p_language_code
608: and pet.element_type_id = pettl.element_type_id
609: and p_effective_date between
610: pet.effective_start_date and pet.effective_end_date