APPS.BEN_PYD_SHD dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 113: from ben_ptip_dpnt_cvg_ctfn_f

109: pyd_attribute28,
110: pyd_attribute29,
111: pyd_attribute30,
112: object_version_number
113: from ben_ptip_dpnt_cvg_ctfn_f
114: where ptip_dpnt_cvg_ctfn_id = p_ptip_dpnt_cvg_ctfn_id
115: and p_effective_date
116: between effective_start_date and effective_end_date;
117: --

Line 188: from ben_ptip_dpnt_cvg_ctfn_f t

184: --
185: Cursor C_Sel1 Is
186: select t.ctfn_rqd_when_rl,
187: t.ptip_id
188: from ben_ptip_dpnt_cvg_ctfn_f t
189: where t.ptip_dpnt_cvg_ctfn_id = p_base_key_value
190: and p_effective_date
191: between t.effective_start_date and t.effective_end_date;
192: --

Line 211: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',

207: -- Call the corresponding datetrack api
208: --
209: dt_api.find_dt_del_modes
210: (p_effective_date => p_effective_date,
211: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
212: p_base_key_column => 'ptip_dpnt_cvg_ctfn_id',
213: p_base_key_value => p_base_key_value,
214: p_parent_table_name1 => 'ff_formulas_f',
215: p_parent_key_column1 => 'formula_id',

Line 248: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',

244: -- Call the corresponding datetrack api
245: --
246: dt_api.find_dt_upd_modes
247: (p_effective_date => p_effective_date,
248: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
249: p_base_key_column => 'ptip_dpnt_cvg_ctfn_id',
250: p_base_key_value => p_base_key_value,
251: p_correction => p_correction,
252: p_update => p_update,

Line 281: (p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',

277: -- version number.
278: --
279: l_object_version_number :=
280: dt_api.get_object_version_number
281: (p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
282: p_base_key_column => 'ptip_dpnt_cvg_ctfn_id',
283: p_base_key_value => p_base_key_value);
284: --
285: hr_utility.set_location(l_proc, 10);

Line 291: update ben_ptip_dpnt_cvg_ctfn_f t

287: --
288: -- Update the specified datetrack row setting the effective
289: -- end date to the specified new effective end date.
290: --
291: update ben_ptip_dpnt_cvg_ctfn_f t
292: set t.effective_end_date = p_new_effective_end_date,
293: t.object_version_number = l_object_version_number
294: where t.ptip_dpnt_cvg_ctfn_id = p_base_key_value
295: and p_effective_date

Line 373: from ben_ptip_dpnt_cvg_ctfn_f

369: pyd_attribute28,
370: pyd_attribute29,
371: pyd_attribute30,
372: object_version_number
373: from ben_ptip_dpnt_cvg_ctfn_f
374: where ptip_dpnt_cvg_ctfn_id = p_ptip_dpnt_cvg_ctfn_id
375: and p_effective_date
376: between effective_start_date and effective_end_date
377: for update nowait;

Line 432: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',

428: --
429: dt_api.validate_dt_mode
430: (p_effective_date => p_effective_date,
431: p_datetrack_mode => p_datetrack_mode,
432: p_base_table_name => 'ben_ptip_dpnt_cvg_ctfn_f',
433: p_base_key_column => 'ptip_dpnt_cvg_ctfn_id',
434: p_base_key_value => p_ptip_dpnt_cvg_ctfn_id,
435: p_parent_table_name1 => 'ff_formulas_f',
436: p_parent_key_column1 => 'formula_id',

Line 472: fnd_message.set_token('TABLE_NAME', 'ben_ptip_dpnt_cvg_ctfn_f');

468: -- The object is locked therefore we need to supply a meaningful
469: -- error message.
470: --
471: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
472: fnd_message.set_token('TABLE_NAME', 'ben_ptip_dpnt_cvg_ctfn_f');
473: fnd_message.raise_error;
474: When l_object_invalid then
475: --
476: -- The object doesn't exist or is invalid

Line 479: fnd_message.set_token('TABLE_NAME', 'ben_ptip_dpnt_cvg_ctfn_f');

475: --
476: -- The object doesn't exist or is invalid
477: --
478: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
479: fnd_message.set_token('TABLE_NAME', 'ben_ptip_dpnt_cvg_ctfn_f');
480: fnd_message.raise_error;
481: End lck;
482: --
483: -- ----------------------------------------------------------------------------