APPS.BEN_BER_SHD dependencies on BEN_ELIG_RSLT_F

Line 57: from ben_elig_rslt_f

53: ,assignment_id
54: ,elig_flag
55: ,business_group_id
56: ,object_version_number
57: from ben_elig_rslt_f
58: where elig_rslt_id = p_elig_rslt_id
59: and p_effective_date
60: between effective_start_date and effective_end_date;
61: --

Line 133: ,p_base_table_name => 'ben_elig_rslt_f'

129: -- Call the corresponding datetrack api
130: --
131: dt_api.find_dt_upd_modes
132: (p_effective_date => p_effective_date
133: ,p_base_table_name => 'ben_elig_rslt_f'
134: ,p_base_key_column => 'elig_rslt_id'
135: ,p_base_key_value => p_base_key_value
136: ,p_correction => p_correction
137: ,p_update => p_update

Line 164: from ben_elig_rslt_f t

160: --
161: Cursor C_Sel1 Is
162: select
163: t.elig_obj_id
164: from ben_elig_rslt_f t
165: where t.elig_rslt_id = p_base_key_value
166: and p_effective_date
167: between t.effective_start_date and t.effective_end_date;
168: --

Line 187: ,p_base_table_name => 'ben_elig_rslt_f'

183: -- Call the corresponding datetrack api
184: --
185: dt_api.find_dt_del_modes
186: (p_effective_date => p_effective_date
187: ,p_base_table_name => 'ben_elig_rslt_f'
188: ,p_base_key_column => 'elig_rslt_id'
189: ,p_base_key_value => p_base_key_value
190: ,p_parent_table_name1 => 'ben_elig_obj_f'
191: ,p_parent_key_column1 => 'elig_obj_id'

Line 225: (p_base_table_name => 'ben_elig_rslt_f'

221: -- version number.
222: --
223: l_object_version_number :=
224: dt_api.get_object_version_number
225: (p_base_table_name => 'ben_elig_rslt_f'
226: ,p_base_key_column => 'elig_rslt_id'
227: ,p_base_key_value => p_base_key_value
228: );
229: --

Line 236: update ben_elig_rslt_f t

232: --
233: -- Update the specified datetrack row setting the effective
234: -- end date to the specified new effective end date.
235: --
236: update ben_elig_rslt_f t
237: set t.effective_end_date = p_new_effective_end_date
238: , t.object_version_number = l_object_version_number
239: where t.elig_rslt_id = p_base_key_value
240: and p_effective_date

Line 280: from ben_elig_rslt_f

276: ,assignment_id
277: ,elig_flag
278: ,business_group_id
279: ,object_version_number
280: from ben_elig_rslt_f
281: where elig_rslt_id = p_elig_rslt_id
282: and p_effective_date
283: between effective_start_date and effective_end_date
284: for update nowait;

Line 343: ,p_base_table_name => 'ben_elig_rslt_f'

339: --
340: dt_api.validate_dt_mode
341: (p_effective_date => p_effective_date
342: ,p_datetrack_mode => p_datetrack_mode
343: ,p_base_table_name => 'ben_elig_rslt_f'
344: ,p_base_key_column => 'elig_rslt_id'
345: ,p_base_key_value => p_elig_rslt_id
346: ,p_parent_table_name1 => 'ben_elig_obj_f'
347: ,p_parent_key_column1 => 'elig_obj_id'

Line 381: fnd_message.set_token('TABLE_NAME', 'ben_elig_rslt_f');

377: -- The object is locked therefore we need to supply a meaningful
378: -- error message.
379: --
380: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
381: fnd_message.set_token('TABLE_NAME', 'ben_elig_rslt_f');
382: fnd_message.raise_error;
383: End lck;
384: --
385: -- ----------------------------------------------------------------------------