APPS.BEN_ADE_SHD dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 112: from ben_apld_dpnt_cvg_elig_prfl_f

108: ade_attribute28,
109: ade_attribute29,
110: ade_attribute30,
111: object_version_number
112: from ben_apld_dpnt_cvg_elig_prfl_f
113: where apld_dpnt_cvg_elig_prfl_id = p_apld_dpnt_cvg_elig_prfl_id
114: and p_effective_date
115: between effective_start_date and effective_end_date;
116: --

Line 193: from ben_apld_dpnt_cvg_elig_prfl_f t

189: t.pgm_id,
190: t.ptip_id,
191: t.dpnt_cvg_eligy_prfl_id,
192: t.pl_id
193: from ben_apld_dpnt_cvg_elig_prfl_f t
194: where t.apld_dpnt_cvg_elig_prfl_id = p_base_key_value
195: and p_effective_date
196: between t.effective_start_date and t.effective_end_date;
197: --

Line 219: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

215: -- Call the corresponding datetrack api
216: --
217: dt_api.find_dt_del_modes
218: (p_effective_date => p_effective_date,
219: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
220: p_base_key_column => 'apld_dpnt_cvg_elig_prfl_id',
221: p_base_key_value => p_base_key_value,
222: p_parent_table_name1 => 'ff_formulas_f',
223: p_parent_key_column1 => 'formula_id',

Line 265: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

261: -- Call the corresponding datetrack api
262: --
263: dt_api.find_dt_upd_modes
264: (p_effective_date => p_effective_date,
265: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
266: p_base_key_column => 'apld_dpnt_cvg_elig_prfl_id',
267: p_base_key_value => p_base_key_value,
268: p_correction => p_correction,
269: p_update => p_update,

Line 298: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

294: -- version number.
295: --
296: l_object_version_number :=
297: dt_api.get_object_version_number
298: (p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
299: p_base_key_column => 'apld_dpnt_cvg_elig_prfl_id',
300: p_base_key_value => p_base_key_value);
301: --
302: hr_utility.set_location(l_proc, 10);

Line 308: update ben_apld_dpnt_cvg_elig_prfl_f t

304: --
305: -- Update the specified datetrack row setting the effective
306: -- end date to the specified new effective end date.
307: --
308: update ben_apld_dpnt_cvg_elig_prfl_f t
309: set t.effective_end_date = p_new_effective_end_date,
310: t.object_version_number = l_object_version_number
311: where t.apld_dpnt_cvg_elig_prfl_id = p_base_key_value
312: and p_effective_date

Line 389: from ben_apld_dpnt_cvg_elig_prfl_f

385: ade_attribute28,
386: ade_attribute29,
387: ade_attribute30,
388: object_version_number
389: from ben_apld_dpnt_cvg_elig_prfl_f
390: where apld_dpnt_cvg_elig_prfl_id = p_apld_dpnt_cvg_elig_prfl_id
391: and p_effective_date
392: between effective_start_date and effective_end_date
393: for update nowait;

Line 448: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',

444: --
445: dt_api.validate_dt_mode
446: (p_effective_date => p_effective_date,
447: p_datetrack_mode => p_datetrack_mode,
448: p_base_table_name => 'ben_apld_dpnt_cvg_elig_prfl_f',
449: p_base_key_column => 'apld_dpnt_cvg_elig_prfl_id',
450: p_base_key_value => p_apld_dpnt_cvg_elig_prfl_id,
451: p_parent_table_name1 => 'ff_formulas_f',
452: p_parent_key_column1 => 'formula_id',

Line 497: fnd_message.set_token('TABLE_NAME', 'ben_apld_dpnt_cvg_elig_prfl_f');

493: -- The object is locked therefore we need to supply a meaningful
494: -- error message.
495: --
496: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
497: fnd_message.set_token('TABLE_NAME', 'ben_apld_dpnt_cvg_elig_prfl_f');
498: fnd_message.raise_error;
499: When l_object_invalid then
500: --
501: -- The object doesn't exist or is invalid

Line 504: fnd_message.set_token('TABLE_NAME', 'ben_apld_dpnt_cvg_elig_prfl_f');

500: --
501: -- The object doesn't exist or is invalid
502: --
503: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
504: fnd_message.set_token('TABLE_NAME', 'ben_apld_dpnt_cvg_elig_prfl_f');
505: fnd_message.raise_error;
506: End lck;
507: --
508: -- ----------------------------------------------------------------------------