APPS.BEN_BEP_SHD dependencies on BEN_ELIG_OBJ_ELIG_PROFL_F

Line 77: from ben_elig_obj_elig_profl_f

73: ,bep_attribute18
74: ,bep_attribute19
75: ,bep_attribute20
76: ,object_version_number
77: from ben_elig_obj_elig_profl_f
78: where elig_obj_elig_prfl_id = p_elig_obj_elig_prfl_id
79: and p_effective_date
80: between effective_start_date and effective_end_date;
81: --

Line 153: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'

149: -- Call the corresponding datetrack api
150: --
151: dt_api.find_dt_upd_modes
152: (p_effective_date => p_effective_date
153: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'
154: ,p_base_key_column => 'elig_obj_elig_prfl_id'
155: ,p_base_key_value => p_base_key_value
156: ,p_correction => p_correction
157: ,p_update => p_update

Line 186: from ben_elig_obj_elig_profl_f t

182: Cursor C_Sel1 Is
183: select
184: t.elig_prfl_id,
185: t.elig_obj_id
186: from ben_elig_obj_elig_profl_f t
187: where t.elig_obj_elig_prfl_id = p_base_key_value
188: and p_effective_date
189: between t.effective_start_date and t.effective_end_date;
190: --

Line 210: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'

206: -- Call the corresponding datetrack api
207: --
208: dt_api.find_dt_del_modes
209: (p_effective_date => p_effective_date
210: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'
211: ,p_base_key_column => 'elig_obj_elig_prfl_id'
212: ,p_base_key_value => p_base_key_value
213: ,p_parent_table_name1 => 'ben_eligy_prfl_f'
214: ,p_parent_key_column1 => 'elig_prfl_id'

Line 251: (p_base_table_name => 'ben_elig_obj_elig_profl_f'

247: -- version number.
248: --
249: l_object_version_number :=
250: dt_api.get_object_version_number
251: (p_base_table_name => 'ben_elig_obj_elig_profl_f'
252: ,p_base_key_column => 'elig_obj_elig_prfl_id'
253: ,p_base_key_value => p_base_key_value
254: );
255: --

Line 262: update ben_elig_obj_elig_profl_f t

258: --
259: -- Update the specified datetrack row setting the effective
260: -- end date to the specified new effective end date.
261: --
262: update ben_elig_obj_elig_profl_f t
263: set t.effective_end_date = p_new_effective_end_date
264: , t.object_version_number = l_object_version_number
265: where t.elig_obj_elig_prfl_id = p_base_key_value
266: and p_effective_date

Line 326: from ben_elig_obj_elig_profl_f

322: ,bep_attribute18
323: ,bep_attribute19
324: ,bep_attribute20
325: ,object_version_number
326: from ben_elig_obj_elig_profl_f
327: where elig_obj_elig_prfl_id = p_elig_obj_elig_prfl_id
328: and p_effective_date
329: between effective_start_date and effective_end_date
330: for update nowait;

Line 389: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'

385: --
386: dt_api.validate_dt_mode
387: (p_effective_date => p_effective_date
388: ,p_datetrack_mode => p_datetrack_mode
389: ,p_base_table_name => 'ben_elig_obj_elig_profl_f'
390: ,p_base_key_column => 'elig_obj_elig_prfl_id'
391: ,p_base_key_value => p_elig_obj_elig_prfl_id
392: ,p_parent_table_name1 => 'ben_eligy_prfl_f'
393: ,p_parent_key_column1 => 'elig_prfl_id'

Line 430: fnd_message.set_token('TABLE_NAME', 'ben_elig_obj_elig_profl_f');

426: -- The object is locked therefore we need to supply a meaningful
427: -- error message.
428: --
429: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
430: fnd_message.set_token('TABLE_NAME', 'ben_elig_obj_elig_profl_f');
431: fnd_message.raise_error;
432: End lck;
433: --
434: -- ----------------------------------------------------------------------------