APPS.PAY_ETU_SHD dependencies on PAY_ELEMENT_TYPE_USAGES_F

Line 63: from pay_element_type_usages_f

59: ,element_type_usage_id
60: ,business_group_id
61: ,legislation_code
62: ,usage_type
63: from pay_element_type_usages_f
64: where element_type_usage_id = p_element_type_usage_id
65: and p_effective_date
66: between effective_start_date and effective_end_date;
67: --

Line 138: ,p_base_table_name => 'pay_element_type_usages_f'

134: -- Call the corresponding datetrack api
135: --
136: dt_api.find_dt_upd_modes
137: (p_effective_date => p_effective_date
138: ,p_base_table_name => 'pay_element_type_usages_f'
139: ,p_base_key_column => 'element_type_usage_id'
140: ,p_base_key_value => p_base_key_value
141: ,p_correction => p_correction
142: ,p_update => p_update

Line 171: from pay_element_type_usages_f t

167: Cursor C_Sel1 Is
168: select
169: t.element_type_id
170: ,t.run_type_id
171: from pay_element_type_usages_f t
172: where t.element_type_usage_id = p_base_key_value
173: and p_effective_date
174: between t.effective_start_date and t.effective_end_date;
175: --

Line 195: ,p_base_table_name => 'pay_element_type_usages_f'

191: -- Call the corresponding datetrack api
192: --
193: dt_api.find_dt_del_modes
194: (p_effective_date => p_effective_date
195: ,p_base_table_name => 'pay_element_type_usages_f'
196: ,p_base_key_column => 'element_type_usage_id'
197: ,p_base_key_value => p_base_key_value
198: ,p_parent_table_name1 => 'pay_element_types_f'
199: ,p_parent_key_column1 => 'element_type_id'

Line 236: (p_base_table_name => 'pay_element_type_usages_f'

232: -- version number.
233: --
234: l_object_version_number :=
235: dt_api.get_object_version_number
236: (p_base_table_name => 'pay_element_type_usages_f'
237: ,p_base_key_column => 'element_type_usage_id'
238: ,p_base_key_value => p_base_key_value
239: );
240: --

Line 247: update pay_element_type_usages_f t

243: --
244: -- Update the specified datetrack row setting the effective
245: -- end date to the specified new effective end date.
246: --
247: update pay_element_type_usages_f t
248: set t.effective_end_date = p_new_effective_end_date
249: , t.object_version_number = l_object_version_number
250: where t.element_type_usage_id = p_base_key_value
251: and p_effective_date

Line 292: from pay_element_type_usages_f

288: ,element_type_usage_id
289: ,business_group_id
290: ,legislation_code
291: ,usage_type
292: from pay_element_type_usages_f
293: where element_type_usage_id = p_element_type_usage_id
294: and p_effective_date
295: between effective_start_date and effective_end_date
296: for update nowait;

Line 355: ,p_base_table_name => 'pay_element_type_usages_f'

351: --
352: dt_api.validate_dt_mode
353: (p_effective_date => p_effective_date
354: ,p_datetrack_mode => p_datetrack_mode
355: ,p_base_table_name => 'pay_element_type_usages_f'
356: ,p_base_key_column => 'element_type_usage_id'
357: ,p_base_key_value => p_element_type_usage_id
358: ,p_parent_table_name1 => 'pay_element_types_f'
359: ,p_parent_key_column1 => 'element_type_id'

Line 396: fnd_message.set_token('TABLE_NAME', 'pay_element_type_usages_f');

392: -- The object is locked therefore we need to supply a meaningful
393: -- error message.
394: --
395: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
396: fnd_message.set_token('TABLE_NAME', 'pay_element_type_usages_f');
397: fnd_message.raise_error;
398: End lck;
399: --
400: -- ----------------------------------------------------------------------------