DBA Data[Home] [Help]

APPS.BEN_ESP_BUS dependencies on PER_SPINAL_POINT_STEPS

Line 160: select 'x' from per_spinal_point_steps

156: l_proc varchar2(72) := g_package||'chk_special_ceiling_step_id';
157: l_api_updating boolean;
158:
159: cursor psps is
160: select 'x' from per_spinal_point_steps
161: where step_id = p_special_ceiling_step_id ;
162: ldummy varchar2(1) ;
163: --
164: Begin

Line 281: (p_base_table_name => 'per_spinal_point_steps_f',

277: Raise l_integrity_error;
278: End If;
279: If ((nvl(p_special_ceiling_step_id, hr_api.g_number) <> hr_api.g_number) and
280: NOT (dt_api.check_min_max_dates
281: (p_base_table_name => 'per_spinal_point_steps_f',
282: p_base_key_column => 'step_id',
283: p_base_key_value => p_special_ceiling_step_id,
284: p_from_date => p_validation_start_date,
285: p_to_date => p_validation_end_date))) Then

Line 286: l_table_name := 'per_spinal_point_steps_f';

282: p_base_key_column => 'step_id',
283: p_base_key_value => p_special_ceiling_step_id,
284: p_from_date => p_validation_start_date,
285: p_to_date => p_validation_end_date))) Then
286: l_table_name := 'per_spinal_point_steps_f';
287: Raise l_integrity_error;
288: End If;
289: --
290: End If;