APPS.BEN_PRY_SHD dependencies on BEN_PRTT_RMT_APRVD_FR_PYMT_F

Line 104: from ben_prtt_rmt_aprvd_fr_pymt_f

100: ,pry_attribute28
101: ,pry_attribute29
102: ,pry_attribute30
103: ,object_version_number
104: from ben_prtt_rmt_aprvd_fr_pymt_f
105: where prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
106: and p_effective_date
107: between effective_start_date and effective_end_date;
108: --

Line 180: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'

176: -- Call the corresponding datetrack api
177: --
178: dt_api.find_dt_upd_modes
179: (p_effective_date => p_effective_date
180: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'
181: ,p_base_key_column => 'prtt_rmt_aprvd_fr_pymt_id'
182: ,p_base_key_value => p_base_key_value
183: ,p_correction => p_correction
184: ,p_update => p_update

Line 221: from ben_prtt_rmt_aprvd_fr_pymt_f t

217: --
218: Cursor C_Sel1 Is
219: select
220: t.prtt_reimbmt_rqst_id
221: from ben_prtt_rmt_aprvd_fr_pymt_f t
222: where t.prtt_rmt_aprvd_fr_pymt_id = p_base_key_value
223: and p_effective_date
224: between t.effective_start_date and t.effective_end_date;
225: --

Line 244: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'

240: -- Call the corresponding datetrack api
241: --
242: dt_api.find_dt_del_modes
243: (p_effective_date => p_effective_date
244: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'
245: ,p_base_key_column => 'prtt_rmt_aprvd_fr_pymt_id'
246: ,p_base_key_value => p_base_key_value
247: ,p_parent_table_name1 => 'ben_prtt_reimbmt_rqst_f'
248: ,p_parent_key_column1 => 'prtt_reimbmt_rqst_id'

Line 296: (p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'

292: -- version number.
293: --
294: l_object_version_number :=
295: dt_api.get_object_version_number
296: (p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'
297: ,p_base_key_column => 'prtt_rmt_aprvd_fr_pymt_id'
298: ,p_base_key_value => p_base_key_value
299: );
300: --

Line 307: update ben_prtt_rmt_aprvd_fr_pymt_f t

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

Line 392: from ben_prtt_rmt_aprvd_fr_pymt_f

388: ,pry_attribute28
389: ,pry_attribute29
390: ,pry_attribute30
391: ,object_version_number
392: from ben_prtt_rmt_aprvd_fr_pymt_f
393: where prtt_rmt_aprvd_fr_pymt_id = p_prtt_rmt_aprvd_fr_pymt_id
394: and p_effective_date
395: between effective_start_date and effective_end_date
396: for update nowait;

Line 455: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'

451: --
452: dt_api.validate_dt_mode
453: (p_effective_date => p_effective_date
454: ,p_datetrack_mode => p_datetrack_mode
455: ,p_base_table_name => 'ben_prtt_rmt_aprvd_fr_pymt_f'
456: ,p_base_key_column => 'prtt_rmt_aprvd_fr_pymt_id'
457: ,p_base_key_value => p_prtt_rmt_aprvd_fr_pymt_id
458: ,p_parent_table_name1 => 'ben_prtt_reimbmt_rqst_f'
459: ,p_parent_key_column1 => 'prtt_reimbmt_rqst_id'

Line 493: fnd_message.set_token('TABLE_NAME', 'ben_prtt_rmt_aprvd_fr_pymt_f');

489: -- The object is locked therefore we need to supply a meaningful
490: -- error message.
491: --
492: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
493: fnd_message.set_token('TABLE_NAME', 'ben_prtt_rmt_aprvd_fr_pymt_f');
494: fnd_message.raise_error;
495: End lck;
496: --
497: -- ----------------------------------------------------------------------------