APPS.PER_SPP_SHD dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 115: from per_spinal_point_placements_f

111: ,information29
112: ,information30
113: ,information_category
114: ,object_version_number
115: from per_spinal_point_placements_f
116: where placement_id = p_placement_id
117: and p_effective_date
118: between effective_start_date and effective_end_date;
119: --

Line 195: per_spinal_point_placements_f spp

191:
192: cursor csr_future_grade_scale is
193: select paa.grade_id
194: from per_all_assignments_f paa,
195: per_spinal_point_placements_f spp
196: where paa.assignment_id = spp.assignment_id
197: and spp.placement_id = p_base_key_value
198: and paa.effective_start_date > p_effective_date
199: and paa.grade_id <> (select paa1.grade_id

Line 212: ,p_base_table_name => 'per_spinal_point_placements_f'

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

Line 258: from per_spinal_point_placements_f t

254: Cursor C_Sel1 Is
255: select
256: t.step_id
257: ,t.assignment_id
258: from per_spinal_point_placements_f t
259: where t.placement_id = p_base_key_value
260: and p_effective_date
261: between t.effective_start_date and t.effective_end_date;
262: --

Line 282: ,p_base_table_name => 'per_spinal_point_placements_f'

278: -- Call the corresponding datetrack api
279: --
280: dt_api.find_dt_del_modes
281: (p_effective_date => p_effective_date
282: ,p_base_table_name => 'per_spinal_point_placements_f'
283: ,p_base_key_column => 'placement_id'
284: ,p_base_key_value => p_base_key_value
285: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
286: ,p_parent_key_column1 => 'step_id'

Line 323: (p_base_table_name => 'per_spinal_point_placements_f'

319: -- version number.
320: --
321: l_object_version_number :=
322: dt_api.get_object_version_number
323: (p_base_table_name => 'per_spinal_point_placements_f'
324: ,p_base_key_column => 'placement_id'
325: ,p_base_key_value => p_base_key_value
326: );
327: --

Line 338: update per_spinal_point_placements_f t

334: --
335: -- Update the specified datetrack row setting the effective
336: -- end date to the specified new effective end date.
337: --
338: update per_spinal_point_placements_f t
339: set t.effective_end_date = p_new_effective_end_date
340: , t.object_version_number = l_object_version_number
341: where t.placement_id = p_base_key_value
342: and p_effective_date

Line 432: from per_spinal_point_placements_f

428: ,information29
429: ,information30
430: ,information_category
431: ,object_version_number
432: from per_spinal_point_placements_f
433: where placement_id = p_placement_id
434: and p_effective_date
435: between effective_start_date and effective_end_date
436: for update nowait;

Line 513: ,p_base_table_name => 'per_spinal_point_placements_f'

509:
510: dt_api.validate_dt_mode
511: (p_effective_date => p_effective_date
512: ,p_datetrack_mode => p_datetrack_mode
513: ,p_base_table_name => 'per_spinal_point_placements_f'
514: ,p_base_key_column => 'placement_id'
515: ,p_base_key_value => p_placement_id
516: ,p_parent_table_name1 => 'per_spinal_point_steps_f'
517: ,p_parent_key_column1 => 'step_id'

Line 532: ,p_base_table_name => 'per_spinal_point_placements_f'

528: --
529: dt_api.validate_dt_mode
530: (p_effective_date => p_effective_date
531: ,p_datetrack_mode => p_datetrack_mode
532: ,p_base_table_name => 'per_spinal_point_placements_f'
533: ,p_base_key_column => 'placement_id'
534: ,p_base_key_value => p_placement_id
535: --,p_parent_table_name1 => 'per_spinal_point_steps_f'
536: --,p_parent_key_column1 => 'step_id'

Line 594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');

590: -- The object is locked therefore we need to supply a meaningful
591: -- error message.
592: --
593: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
594: fnd_message.set_token('TABLE_NAME', 'per_spinal_point_placements_f');
595: fnd_message.raise_error;
596: End lck;
597: --
598: -- ----------------------------------------------------------------------------