APPS.BEN_PPV_SHD dependencies on BEN_PRTL_MO_RT_PRTN_VAL_F

Line 114: from ben_prtl_mo_rt_prtn_val_f

110: pmrpv_attribute28,
111: pmrpv_attribute29,
112: pmrpv_attribute30,
113: object_version_number
114: from ben_prtl_mo_rt_prtn_val_f
115: where prtl_mo_rt_prtn_val_id = p_prtl_mo_rt_prtn_val_id
116: and p_effective_date
117: between effective_start_date and effective_end_date;
118: --

Line 191: from ben_prtl_mo_rt_prtn_val_f t

187: Cursor C_Sel1 Is
188: select t.actl_prem_id,
189: t.cvg_amt_calc_mthd_id,
190: t.acty_base_rt_id
191: from ben_prtl_mo_rt_prtn_val_f t
192: where t.prtl_mo_rt_prtn_val_id = p_base_key_value
193: and p_effective_date
194: between t.effective_start_date and t.effective_end_date;
195: --

Line 215: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',

211: -- Call the corresponding datetrack api
212: --
213: dt_api.find_dt_del_modes
214: (p_effective_date => p_effective_date,
215: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',
216: p_base_key_column => 'prtl_mo_rt_prtn_val_id',
217: p_base_key_value => p_base_key_value,
218: p_parent_table_name1 => 'ben_actl_prem_f',
219: p_parent_key_column1 => 'actl_prem_id',

Line 255: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',

251: -- Call the corresponding datetrack api
252: --
253: dt_api.find_dt_upd_modes
254: (p_effective_date => p_effective_date,
255: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',
256: p_base_key_column => 'prtl_mo_rt_prtn_val_id',
257: p_base_key_value => p_base_key_value,
258: p_correction => p_correction,
259: p_update => p_update,

Line 288: (p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',

284: -- version number.
285: --
286: l_object_version_number :=
287: dt_api.get_object_version_number
288: (p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',
289: p_base_key_column => 'prtl_mo_rt_prtn_val_id',
290: p_base_key_value => p_base_key_value);
291: --
292: hr_utility.set_location(l_proc, 10);

Line 298: update ben_prtl_mo_rt_prtn_val_f t

294: --
295: -- Update the specified datetrack row setting the effective
296: -- end date to the specified new effective end date.
297: --
298: update ben_prtl_mo_rt_prtn_val_f t
299: set t.effective_end_date = p_new_effective_end_date,
300: t.object_version_number = l_object_version_number
301: where t.prtl_mo_rt_prtn_val_id = p_base_key_value
302: and p_effective_date

Line 385: from ben_prtl_mo_rt_prtn_val_f

381: pmrpv_attribute28,
382: pmrpv_attribute29,
383: pmrpv_attribute30,
384: object_version_number
385: from ben_prtl_mo_rt_prtn_val_f
386: where prtl_mo_rt_prtn_val_id = p_prtl_mo_rt_prtn_val_id
387: and p_effective_date
388: between effective_start_date and effective_end_date
389: for update nowait;

Line 444: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',

440: --
441: dt_api.validate_dt_mode
442: (p_effective_date => p_effective_date,
443: p_datetrack_mode => p_datetrack_mode,
444: p_base_table_name => 'ben_prtl_mo_rt_prtn_val_f',
445: p_base_key_column => 'prtl_mo_rt_prtn_val_id',
446: p_base_key_value => p_prtl_mo_rt_prtn_val_id,
447: p_parent_table_name1 => 'ben_actl_prem_f',
448: p_parent_key_column1 => 'actl_prem_id',

Line 487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');

483: -- The object is locked therefore we need to supply a meaningful
484: -- error message.
485: --
486: hr_utility.set_message('PAY', 'HR_7165_OBJECT_LOCKED');
487: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
488: hr_utility.raise_error;
489: When l_object_invalid then
490: --
491: -- The object doesn't exist or is invalid

Line 494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');

490: --
491: -- The object doesn't exist or is invalid
492: --
493: hr_utility.set_message('PAY', 'HR_7155_OBJECT_INVALID');
494: hr_utility.set_message_token('TABLE_NAME', 'ben_prtl_mo_rt_prtn_val_f');
495: hr_utility.raise_error;
496: End lck;
497: --
498: -- ----------------------------------------------------------------------------