APPS.BEN_ELU_SHD dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 112: from ben_elig_lbr_mmbr_prte_f

108: elu_attribute30,
109: object_version_number,
110: criteria_score,
111: criteria_weight
112: from ben_elig_lbr_mmbr_prte_f
113: where elig_lbr_mmbr_prte_id = p_elig_lbr_mmbr_prte_id
114: and p_effective_date
115: between effective_start_date and effective_end_date;
116: --

Line 192: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',

188: -- Call the corresponding datetrack api
189: --
190: dt_api.find_dt_del_modes
191: (p_effective_date => p_effective_date,
192: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',
193: p_base_key_column => 'elig_lbr_mmbr_prte_id',
194: p_base_key_value => p_base_key_value,
195: p_zap => p_zap,
196: p_delete => p_delete,

Line 223: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',

219: -- Call the corresponding datetrack api
220: --
221: dt_api.find_dt_upd_modes
222: (p_effective_date => p_effective_date,
223: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',
224: p_base_key_column => 'elig_lbr_mmbr_prte_id',
225: p_base_key_value => p_base_key_value,
226: p_correction => p_correction,
227: p_update => p_update,

Line 256: (p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',

252: -- version number.
253: --
254: l_object_version_number :=
255: dt_api.get_object_version_number
256: (p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',
257: p_base_key_column => 'elig_lbr_mmbr_prte_id',
258: p_base_key_value => p_base_key_value);
259: --
260: hr_utility.set_location(l_proc, 10);

Line 266: update ben_elig_lbr_mmbr_prte_f t

262: --
263: -- Update the specified datetrack row setting the effective
264: -- end date to the specified new effective end date.
265: --
266: update ben_elig_lbr_mmbr_prte_f t
267: set t.effective_end_date = p_new_effective_end_date,
268: t.object_version_number = l_object_version_number
269: where t.elig_lbr_mmbr_prte_id = p_base_key_value
270: and p_effective_date

Line 348: from ben_elig_lbr_mmbr_prte_f

344: object_version_number,
345: criteria_score,
346: criteria_weight
347:
348: from ben_elig_lbr_mmbr_prte_f
349: where elig_lbr_mmbr_prte_id = p_elig_lbr_mmbr_prte_id
350: and p_effective_date
351: between effective_start_date and effective_end_date
352: for update nowait;

Line 407: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',

403: --
404: dt_api.validate_dt_mode
405: (p_effective_date => p_effective_date,
406: p_datetrack_mode => p_datetrack_mode,
407: p_base_table_name => 'ben_elig_lbr_mmbr_prte_f',
408: p_base_key_column => 'elig_lbr_mmbr_prte_id',
409: p_base_key_value => p_elig_lbr_mmbr_prte_id,
410:
411: p_enforce_foreign_locking => true,

Line 442: fnd_message.set_token('TABLE_NAME', 'ben_elig_lbr_mmbr_prte_f');

438: -- The object is locked therefore we need to supply a meaningful
439: -- error message.
440: --
441: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
442: fnd_message.set_token('TABLE_NAME', 'ben_elig_lbr_mmbr_prte_f');
443: fnd_message.raise_error;
444: When l_object_invalid then
445: --
446: -- The object doesn't exist or is invalid

Line 449: fnd_message.set_token('TABLE_NAME', 'ben_elig_lbr_mmbr_prte_f');

445: --
446: -- The object doesn't exist or is invalid
447: --
448: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
449: fnd_message.set_token('TABLE_NAME', 'ben_elig_lbr_mmbr_prte_f');
450: fnd_message.raise_error;
451: End lck;
452: --
453: -- ----------------------------------------------------------------------------