APPS.PAY_ROM_SHD dependencies on PAY_RUN_TYPE_ORG_METHODS_F

Line 64: from pay_run_type_org_methods_f

60: ,object_version_number
61: ,run_type_org_method_id
62: ,business_group_id
63: ,legislation_code
64: from pay_run_type_org_methods_f
65: where run_type_org_method_id = p_run_type_org_method_id
66: and p_effective_date
67: between effective_start_date and effective_end_date;
68: --

Line 139: ,p_base_table_name => 'pay_run_type_org_methods_f'

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

Line 172: from pay_run_type_org_methods_f t

168: Cursor C_Sel1 Is
169: select
170: t.org_payment_method_id
171: ,t.run_type_id
172: from pay_run_type_org_methods_f t
173: where t.run_type_org_method_id = p_base_key_value
174: and p_effective_date
175: between t.effective_start_date and t.effective_end_date;
176: --

Line 196: ,p_base_table_name => 'pay_run_type_org_methods_f'

192: -- Call the corresponding datetrack api
193: --
194: dt_api.find_dt_del_modes
195: (p_effective_date => p_effective_date
196: ,p_base_table_name => 'pay_run_type_org_methods_f'
197: ,p_base_key_column => 'run_type_org_method_id'
198: ,p_base_key_value => p_base_key_value
199: ,p_parent_table_name1 => 'pay_org_payment_methods_f'
200: ,p_parent_key_column1 => 'org_payment_method_id'

Line 237: (p_base_table_name => 'pay_run_type_org_methods_f'

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

Line 248: update pay_run_type_org_methods_f t

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

Line 294: from pay_run_type_org_methods_f

290: ,object_version_number
291: ,run_type_org_method_id
292: ,business_group_id
293: ,legislation_code
294: from pay_run_type_org_methods_f
295: where run_type_org_method_id = p_run_type_org_method_id
296: and p_effective_date
297: between effective_start_date and effective_end_date
298: for update nowait;

Line 357: ,p_base_table_name => 'pay_run_type_org_methods_f'

353: --
354: dt_api.validate_dt_mode
355: (p_effective_date => p_effective_date
356: ,p_datetrack_mode => p_datetrack_mode
357: ,p_base_table_name => 'pay_run_type_org_methods_f'
358: ,p_base_key_column => 'run_type_org_method_id'
359: ,p_base_key_value => p_run_type_org_method_id
360: ,p_parent_table_name1 => 'pay_org_payment_methods_f'
361: ,p_parent_key_column1 => 'org_payment_method_id'

Line 398: fnd_message.set_token('TABLE_NAME', 'pay_run_type_org_methods_f');

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