APPS.BEN_PBR_SHD dependencies on BEN_PY_BSS_RT_F

Line 105: from ben_py_bss_rt_f

101: pbr_attribute28,
102: pbr_attribute29,
103: pbr_attribute30,
104: object_version_number
105: from ben_py_bss_rt_f
106: where py_bss_rt_id = p_py_bss_rt_id
107: and p_effective_date
108: between effective_start_date and effective_end_date;
109: --

Line 178: from ben_py_bss_rt_f t

174: l_parent_key_value1 number;
175: --
176: Cursor C_Sel1 Is
177: select t.vrbl_rt_prfl_id
178: from ben_py_bss_rt_f t
179: where t.py_bss_rt_id = p_base_key_value
180: and p_effective_date
181: between t.effective_start_date and t.effective_end_date;
182: --

Line 201: p_base_table_name => 'ben_py_bss_rt_f',

197: -- Call the corresponding datetrack api
198: --
199: dt_api.find_dt_del_modes
200: (p_effective_date => p_effective_date,
201: p_base_table_name => 'ben_py_bss_rt_f',
202: p_base_key_column => 'py_bss_rt_id',
203: p_base_key_value => p_base_key_value,
204: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
205: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 235: p_base_table_name => 'ben_py_bss_rt_f',

231: -- Call the corresponding datetrack api
232: --
233: dt_api.find_dt_upd_modes
234: (p_effective_date => p_effective_date,
235: p_base_table_name => 'ben_py_bss_rt_f',
236: p_base_key_column => 'py_bss_rt_id',
237: p_base_key_value => p_base_key_value,
238: p_correction => p_correction,
239: p_update => p_update,

Line 268: (p_base_table_name => 'ben_py_bss_rt_f',

264: -- version number.
265: --
266: l_object_version_number :=
267: dt_api.get_object_version_number
268: (p_base_table_name => 'ben_py_bss_rt_f',
269: p_base_key_column => 'py_bss_rt_id',
270: p_base_key_value => p_base_key_value);
271: --
272: hr_utility.set_location(l_proc, 10);

Line 278: update ben_py_bss_rt_f t

274: --
275: -- Update the specified datetrack row setting the effective
276: -- end date to the specified new effective end date.
277: --
278: update ben_py_bss_rt_f t
279: set t.effective_end_date = p_new_effective_end_date,
280: t.object_version_number = l_object_version_number
281: where t.py_bss_rt_id = p_base_key_value
282: and p_effective_date

Line 357: from ben_py_bss_rt_f

353: pbr_attribute28,
354: pbr_attribute29,
355: pbr_attribute30,
356: object_version_number
357: from ben_py_bss_rt_f
358: where py_bss_rt_id = p_py_bss_rt_id
359: and p_effective_date
360: between effective_start_date and effective_end_date
361: for update nowait;

Line 416: p_base_table_name => 'ben_py_bss_rt_f',

412: --
413: dt_api.validate_dt_mode
414: (p_effective_date => p_effective_date,
415: p_datetrack_mode => p_datetrack_mode,
416: p_base_table_name => 'ben_py_bss_rt_f',
417: p_base_key_column => 'py_bss_rt_id',
418: p_base_key_value => p_py_bss_rt_id,
419: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
420: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 453: hr_utility.set_message_token('TABLE_NAME', 'ben_py_bss_rt_f');

449: -- The object is locked therefore we need to supply a meaningful
450: -- error message.
451: --
452: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
453: hr_utility.set_message_token('TABLE_NAME', 'ben_py_bss_rt_f');
454: hr_utility.raise_error;
455: When l_object_invalid then
456: --
457: -- The object doesn't exist or is invalid

Line 460: hr_utility.set_message_token('TABLE_NAME', 'ben_py_bss_rt_f');

456: --
457: -- The object doesn't exist or is invalid
458: --
459: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
460: hr_utility.set_message_token('TABLE_NAME', 'ben_py_bss_rt_f');
461: hr_utility.raise_error;
462: End lck;
463: --
464: -- ----------------------------------------------------------------------------