APPS.BEN_ESW_SHD dependencies on BEN_ELIG_SCRE_WTG_F

Line 61: from ben_elig_scre_wtg_f

57: ,crit_tab_short_name
58: ,crit_tab_pk_id
59: ,computed_score
60: ,benefit_action_id
61: from ben_elig_scre_wtg_f
62: where elig_scre_wtg_id = p_elig_scre_wtg_id
63: and p_effective_date
64: between effective_start_date and effective_end_date;
65: --

Line 137: ,p_base_table_name => 'ben_elig_scre_wtg_f'

133: -- Call the corresponding datetrack api
134: --
135: dt_api.find_dt_upd_modes
136: (p_effective_date => p_effective_date
137: ,p_base_table_name => 'ben_elig_scre_wtg_f'
138: ,p_base_key_column => 'elig_scre_wtg_id'
139: ,p_base_key_value => p_base_key_value
140: ,p_correction => p_correction
141: ,p_update => p_update

Line 171: ,p_base_table_name => 'ben_elig_scre_wtg_f'

167: -- Call the corresponding datetrack api
168: --
169: dt_api.find_dt_del_modes
170: (p_effective_date => p_effective_date
171: ,p_base_table_name => 'ben_elig_scre_wtg_f'
172: ,p_base_key_column => 'elig_scre_wtg_id'
173: ,p_base_key_value => p_base_key_value
174: ,p_zap => p_zap
175: ,p_delete => p_delete

Line 206: (p_base_table_name => 'ben_elig_scre_wtg_f'

202: -- version number.
203: --
204: l_object_version_number :=
205: dt_api.get_object_version_number
206: (p_base_table_name => 'ben_elig_scre_wtg_f'
207: ,p_base_key_column => 'elig_scre_wtg_id'
208: ,p_base_key_value => p_base_key_value
209: );
210: --

Line 217: update ben_elig_scre_wtg_f t

213: --
214: -- Update the specified datetrack row setting the effective
215: -- end date to the specified new effective end date.
216: --
217: update ben_elig_scre_wtg_f t
218: set t.effective_end_date = p_new_effective_end_date
219: , t.object_version_number = l_object_version_number
220: where t.elig_scre_wtg_id = p_base_key_value
221: and p_effective_date

Line 265: from ben_elig_scre_wtg_f

261: ,crit_tab_short_name
262: ,crit_tab_pk_id
263: ,computed_score
264: ,benefit_action_id
265: from ben_elig_scre_wtg_f
266: where elig_scre_wtg_id = p_elig_scre_wtg_id
267: and p_effective_date
268: between effective_start_date and effective_end_date
269: for update nowait;

Line 328: ,p_base_table_name => 'ben_elig_scre_wtg_f'

324: --
325: dt_api.validate_dt_mode
326: (p_effective_date => p_effective_date
327: ,p_datetrack_mode => p_datetrack_mode
328: ,p_base_table_name => 'ben_elig_scre_wtg_f'
329: ,p_base_key_column => 'elig_scre_wtg_id'
330: ,p_base_key_value => p_elig_scre_wtg_id
331: ,p_enforce_foreign_locking => true
332: ,p_validation_start_date => l_validation_start_date

Line 363: fnd_message.set_token('TABLE_NAME', 'ben_elig_scre_wtg_f');

359: -- The object is locked therefore we need to supply a meaningful
360: -- error message.
361: --
362: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
363: fnd_message.set_token('TABLE_NAME', 'ben_elig_scre_wtg_f');
364: fnd_message.raise_error;
365: End lck;
366: --
367: -- ----------------------------------------------------------------------------