APPS.BEN_HSR_SHD dependencies on BEN_HRLY_SLRD_RT_F

Line 105: from ben_hrly_slrd_rt_f

101: hsr_attribute28,
102: hsr_attribute29,
103: hsr_attribute30,
104: object_version_number
105: from ben_hrly_slrd_rt_f
106: where hrly_slrd_rt_id = p_hrly_slrd_rt_id
107: and p_effective_date
108: between effective_start_date and effective_end_date;
109: --

Line 178: from ben_hrly_slrd_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_hrly_slrd_rt_f t
179: where t.hrly_slrd_rt_id = p_base_key_value
180: and p_effective_date
181: between t.effective_start_date and t.effective_end_date;
182: --

Line 200: p_base_table_name => 'ben_hrly_slrd_rt_f',

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

Line 234: p_base_table_name => 'ben_hrly_slrd_rt_f',

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

Line 267: (p_base_table_name => 'ben_hrly_slrd_rt_f',

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

Line 277: update ben_hrly_slrd_rt_f t

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

Line 356: from ben_hrly_slrd_rt_f

352: hsr_attribute28,
353: hsr_attribute29,
354: hsr_attribute30,
355: object_version_number
356: from ben_hrly_slrd_rt_f
357: where hrly_slrd_rt_id = p_hrly_slrd_rt_id
358: and p_effective_date
359: between effective_start_date and effective_end_date
360: for update nowait;

Line 415: p_base_table_name => 'ben_hrly_slrd_rt_f',

411: --
412: dt_api.validate_dt_mode
413: (p_effective_date => p_effective_date,
414: p_datetrack_mode => p_datetrack_mode,
415: p_base_table_name => 'ben_hrly_slrd_rt_f',
416: p_base_key_column => 'hrly_slrd_rt_id',
417: p_base_key_value => p_hrly_slrd_rt_id,
418: p_parent_table_name1 => 'ben_vrbl_rt_prfl_f',
419: p_parent_key_column1 => 'vrbl_rt_prfl_id',

Line 452: hr_utility.set_message_token('TABLE_NAME', 'ben_hrly_slrd_rt_f');

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

Line 459: hr_utility.set_message_token('TABLE_NAME', 'ben_hrly_slrd_rt_f');

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