APPS.PER_ASG_BUS2 dependencies on PER_SPINAL_POINT_STEPS_F

Line 4271: l_sequence per_spinal_point_steps_f.sequence%TYPE;

4267: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4268: )
4269: is
4270: --
4271: l_sequence per_spinal_point_steps_f.sequence%TYPE;
4272: l_exists varchar2(1);
4273: l_api_updating boolean;
4274: l_business_group_id number(15);
4275: l_proc varchar2(72) := g_package||'chk_special_ceiling_step_id';

Line 4282: from per_spinal_point_steps_f psps

4278: select 1
4279: from sys.dual
4280: where exists
4281: (select null
4282: from per_spinal_point_steps_f psps
4283: where psps.effective_start_date <= p_validation_start_date
4284: and psps.step_id = p_special_ceiling_step_id
4285: and (exists
4286: (select null

Line 4287: from per_spinal_point_steps_f psps2

4283: where psps.effective_start_date <= p_validation_start_date
4284: and psps.step_id = p_special_ceiling_step_id
4285: and (exists
4286: (select null
4287: from per_spinal_point_steps_f psps2
4288: where psps2.effective_end_date >= p_validation_end_date
4289: and psps2.step_id = p_special_ceiling_step_id
4290: and psps2.grade_spine_id = psps.grade_spine_id)));
4291: --

Line 4302: per_spinal_point_steps_f psps

4298: --
4299: cursor csr_valid_step_grade is
4300: select psps.sequence
4301: from per_grade_spines_f pgs,
4302: per_spinal_point_steps_f psps
4303: where psps.step_id = p_special_ceiling_step_id
4304: and pgs.grade_id = p_grade_id
4305: and pgs.grade_spine_id = psps.grade_spine_id
4306: and p_effective_date between pgs.effective_start_date

Line 4316: , per_spinal_point_steps_f psps

4312: select 1
4313: from sys.dual
4314: where exists(select null
4315: from per_spinal_point_placements_f pspp
4316: , per_spinal_point_steps_f psps
4317: , per_grade_spines_f pgs
4318: where pspp.assignment_id = p_assignment_id
4319: and pspp.step_id = psps.step_id
4320: and psps.grade_spine_id=pgs.grade_spine_id