APPS.HR_CLE_SHD dependencies on HR_DE_SOC_INS_CONTR_LVLS_F

Line 102: from hr_de_soc_ins_contr_lvls_f

98: ,month2_min_contribution
99: ,month2_max_contribution
100: ,employee_contribution
101: ,contribution_level_type
102: from hr_de_soc_ins_contr_lvls_f
103: where soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
104: and p_effective_date
105: between effective_start_date and effective_end_date;
106: --

Line 178: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'

174: -- Call the corresponding datetrack api
175: --
176: dt_api.find_dt_upd_modes
177: (p_effective_date => p_effective_date
178: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'
179: ,p_base_key_column => 'soc_ins_contr_lvls_id'
180: ,p_base_key_value => p_base_key_value
181: ,p_correction => p_correction
182: ,p_update => p_update

Line 212: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'

208: -- Call the corresponding datetrack api
209: --
210: dt_api.find_dt_del_modes
211: (p_effective_date => p_effective_date
212: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'
213: ,p_base_key_column => 'soc_ins_contr_lvls_id'
214: ,p_base_key_value => p_base_key_value
215: ,p_zap => p_zap
216: ,p_delete => p_delete

Line 247: (p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'

243: -- version number.
244: --
245: l_object_version_number :=
246: dt_api.get_object_version_number
247: (p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'
248: ,p_base_key_column => 'soc_ins_contr_lvls_id'
249: ,p_base_key_value => p_base_key_value
250: );
251: --

Line 258: update hr_de_soc_ins_contr_lvls_f t

254: --
255: -- Update the specified datetrack row setting the effective
256: -- end date to the specified new effective end date.
257: --
258: update hr_de_soc_ins_contr_lvls_f t
259: set t.effective_end_date = p_new_effective_end_date
260: , t.object_version_number = l_object_version_number
261: where t.soc_ins_contr_lvls_id = p_base_key_value
262: and p_effective_date

Line 347: from hr_de_soc_ins_contr_lvls_f

343: ,month2_min_contribution
344: ,month2_max_contribution
345: ,employee_contribution
346: ,contribution_level_type
347: from hr_de_soc_ins_contr_lvls_f
348: where soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
349: and p_effective_date
350: between effective_start_date and effective_end_date
351: for update nowait;

Line 415: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'

411: --
412: dt_api.validate_dt_mode
413: (p_effective_date => p_effective_date
414: ,p_datetrack_mode => p_datetrack_mode
415: ,p_base_table_name => 'hr_de_soc_ins_contr_lvls_f'
416: ,p_base_key_column => 'soc_ins_contr_lvls_id'
417: ,p_base_key_value => p_soc_ins_contr_lvls_id
418: ,p_enforce_foreign_locking => true
419: ,p_validation_start_date => l_validation_start_date

Line 450: fnd_message.set_token('TABLE_NAME', 'hr_de_soc_ins_contr_lvls_f');

446: -- The object is locked therefore we need to supply a meaningful
447: -- error message.
448: --
449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
450: fnd_message.set_token('TABLE_NAME', 'hr_de_soc_ins_contr_lvls_f');
451: fnd_message.raise_error;
452: End lck;
453: --
454: -- ----------------------------------------------------------------------------