APPS.PER_SPS_DEL dependencies on PER_SPINAL_POINT_STEPS_F

Line 71: delete from per_spinal_point_steps_f

67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --
71: delete from per_spinal_point_steps_f
72: where step_id = p_rec.step_id
73: and effective_start_date = p_validation_start_date;
74: --
75: per_sps_shd.g_api_dml := false; -- Unset the api dml status

Line 82: delete from per_spinal_point_steps_f

78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --
82: delete from per_spinal_point_steps_f
83: where step_id = p_rec.step_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: per_sps_shd.g_api_dml := false; -- Unset the api dml status

Line 176: ,per_spinal_point_steps_f step

172: cursor csr_get_grade_id is
173: select spine.grade_id
174: ,step.spinal_point_id
175: from per_grade_spines_f spine
176: ,per_spinal_point_steps_f step
177: where step.step_id = p_rec.step_id
178: and p_effective_date between
179: step.effective_start_date and step.effective_end_date
180: and step.grade_spine_id = spine.grade_spine_id

Line 463: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'

459: --
460: when hr_api.cannot_find_prog_unit then
461: --
462: hr_api.cannot_find_prog_unit_error
463: (p_module_name => 'PER_SPINAL_POINT_STEPS_F'
464: ,p_hook_type => 'AD');
465: --
466: end;
467: --