APPS.PAY_RTU_SHD dependencies on PAY_RUN_TYPE_USAGES_F

Line 62: from pay_run_type_usages_f

58: ,object_version_number
59: ,run_type_usage_id
60: ,business_group_id
61: ,legislation_code
62: from pay_run_type_usages_f
63: where run_type_usage_id = p_run_type_usage_id
64: and p_effective_date
65: between effective_start_date and effective_end_date;
66: --

Line 137: ,p_base_table_name => 'pay_run_type_usages_f'

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

Line 170: from pay_run_type_usages_f t

166: Cursor C_Sel1 Is
167: select
168: t.parent_run_type_id
169: ,t.child_run_type_id
170: from pay_run_type_usages_f t
171: where t.run_type_usage_id = p_base_key_value
172: and p_effective_date
173: between t.effective_start_date and t.effective_end_date;
174: --

Line 194: ,p_base_table_name => 'pay_run_type_usages_f'

190: -- Call the corresponding datetrack api
191: --
192: dt_api.find_dt_del_modes
193: (p_effective_date => p_effective_date
194: ,p_base_table_name => 'pay_run_type_usages_f'
195: ,p_base_key_column => 'run_type_usage_id'
196: ,p_base_key_value => p_base_key_value
197: ,p_parent_table_name1 => 'pay_run_types_f'
198: ,p_parent_key_column1 => 'run_type_id'

Line 235: (p_base_table_name => 'pay_run_type_usages_f'

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

Line 246: update pay_run_type_usages_f t

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

Line 290: from pay_run_type_usages_f

286: ,object_version_number
287: ,run_type_usage_id
288: ,business_group_id
289: ,legislation_code
290: from pay_run_type_usages_f
291: where run_type_usage_id = p_run_type_usage_id
292: and p_effective_date
293: between effective_start_date and effective_end_date
294: for update nowait;

Line 355: ,p_base_table_name => 'pay_run_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_run_type_usages_f'
356: ,p_base_key_column => 'run_type_usage_id'
357: ,p_base_key_value => p_run_type_usage_id
358: ,p_parent_table_name1 => 'pay_run_types_f'
359: ,p_parent_key_column1 => 'run_type_id'

Line 396: fnd_message.set_token('TABLE_NAME', 'pay_run_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_run_type_usages_f');
397: fnd_message.raise_error;
398: End lck;
399: --
400: -- ----------------------------------------------------------------------------