APPS.PER_ABV_SHD dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 137: from per_assignment_budget_values_f

133: ,program_update_date
134: ,effective_start_date
135: ,effective_end_date
136: ,object_version_number
137: from per_assignment_budget_values_f
138: where assignment_budget_value_id = p_assignment_budget_value_id
139: and p_effective_date
140: between effective_start_date and effective_end_date;
141: --

Line 211: ,p_base_table_name => 'per_assignment_budget_values_f'

207: -- Call the corresponding datetrack api
208: --
209: dt_api.find_dt_upd_modes
210: (p_effective_date => p_effective_date
211: ,p_base_table_name => 'per_assignment_budget_values_f'
212: ,p_base_key_column => 'assignment_budget_value_id'
213: ,p_base_key_value => p_base_key_value
214: ,p_correction => p_correction
215: ,p_update => p_update

Line 242: from per_assignment_budget_values_f t

238: --
239: Cursor C_Sel1 Is
240: select
241: t.assignment_id
242: from per_assignment_budget_values_f t
243: where t.assignment_budget_value_id = p_base_key_value
244: and p_effective_date
245: between t.effective_start_date and t.effective_end_date;
246: --

Line 265: ,p_base_table_name => 'per_assignment_budget_values_f'

261: -- Call the corresponding datetrack api
262: --
263: dt_api.find_dt_del_modes
264: (p_effective_date => p_effective_date
265: ,p_base_table_name => 'per_assignment_budget_values_f'
266: ,p_base_key_column => 'assignment_budget_value_id'
267: ,p_base_key_value => p_base_key_value
268: ,p_parent_table_name1 => 'per_all_assignments_f'
269: ,p_parent_key_column1 => 'assignment_id'

Line 303: (p_base_table_name => 'per_assignment_budget_values_f',

299: -- version number.
300: --
301: l_object_version_number :=
302: dt_api.get_object_version_number
303: (p_base_table_name => 'per_assignment_budget_values_f',
304: p_base_key_column => 'assignment_budget_value_id',
305: p_base_key_value => p_base_key_value);
306: --
307: hr_utility.set_location(l_proc, 10);

Line 314: update per_assignment_budget_values_f t

310: --
311: -- Update the specified datetrack row setting the effective
312: -- end date to the specified new effective end date.
313: --
314: update per_assignment_budget_values_f t
315: set t.effective_end_date = p_new_effective_end_date
316: where t.assignment_budget_value_id = p_base_key_value
317: and p_effective_date
318: between t.effective_start_date and t.effective_end_date;

Line 361: from per_assignment_budget_values_f

357: ,program_update_date
358: ,effective_start_date
359: ,effective_end_date
360: ,object_version_number
361: from per_assignment_budget_values_f
362: where assignment_budget_value_id = p_assignment_budget_value_id
363: and p_effective_date
364: between effective_start_date and effective_end_date
365: for update nowait;

Line 424: ,p_base_table_name => 'per_assignment_budget_values_f'

420: --
421: dt_api.validate_dt_mode
422: (p_effective_date => p_effective_date
423: ,p_datetrack_mode => p_datetrack_mode
424: ,p_base_table_name => 'per_assignment_budget_values_f'
425: ,p_base_key_column => 'assignment_budget_value_id'
426: ,p_base_key_value => p_assignment_budget_value_id
427: ,p_parent_table_name1 => 'per_all_assignments_f'
428: ,p_parent_key_column1 => 'assignment_id'

Line 462: fnd_message.set_token('TABLE_NAME', 'per_assignment_budget_values_f');

458: -- The object is locked therefore we need to supply a meaningful
459: -- error message.
460: --
461: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
462: fnd_message.set_token('TABLE_NAME', 'per_assignment_budget_values_f');
463: fnd_message.raise_error;
464: End lck;
465: --
466: -- ----------------------------------------------------------------------------