125: where element_type_id = c_element_type_id;
126:
127: cursor c_get_mapping_name2(p_id in number, p_id1 in number, p_date in date) is
128: select piv.name name
129: from pay_input_values_f piv
130: where ( piv.business_group_id is null or piv.business_group_id = p_business_group_id )
131: and piv.element_type_id = p_id1
132: and p_date between piv.effective_start_date and
133: piv.effective_end_date
134: and piv.input_value_id = p_id;
135:
136: cursor c_input_value_start_date(c_input_value_id number) is
137: select min(effective_start_date) effective_start_date
138: from pay_input_values_f
139: where input_value_id = c_input_value_id;
140:
141: -- PDW
142:
171: l_mapping_name1 varchar2(600);
172: l_mapping_column_name1 pqh_attributes.attribute_name%type;
173: l_mapping_column_name2 pqh_attributes.attribute_name%type;
174:
175: l_input_value_name pay_input_values_f.name%type;
176:
177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;
178:
179: l_element_type_start_date pay_element_types_f.effective_start_date%type;
176:
177: l_abr_acty_base_rt_esd ben_acty_base_rt_f.effective_start_date%type;
178:
179: l_element_type_start_date pay_element_types_f.effective_start_date%type;
180: l_input_value_start_date pay_input_values_f.effective_start_date%type;
181:
182: ---------------------------------------------------------------
183: -- END OF BEN_ACTY_BASE_RT_F ----------------------
184: ---------------------------------------------------------------