APPS.PER_ASG_BUS2 dependencies on PER_SPINAL_POINT_STEPS_F

Line 4231: l_sequence per_spinal_point_steps_f.sequence%TYPE;

4227: ,p_object_version_number in per_all_assignments_f.object_version_number%TYPE
4228: )
4229: is
4230: --
4231: l_sequence per_spinal_point_steps_f.sequence%TYPE;
4232: l_exists varchar2(1);
4233: l_api_updating boolean;
4234: l_business_group_id number(15);
4235: l_proc varchar2(72) := g_package||'chk_special_ceiling_step_id';

Line 4242: from per_spinal_point_steps_f psps

4238: select 1
4239: from sys.dual
4240: where exists
4241: (select null
4242: from per_spinal_point_steps_f psps
4243: where psps.effective_start_date <= p_validation_start_date
4244: and psps.step_id = p_special_ceiling_step_id
4245: and (exists
4246: (select null

Line 4247: from per_spinal_point_steps_f psps2

4243: where psps.effective_start_date <= p_validation_start_date
4244: and psps.step_id = p_special_ceiling_step_id
4245: and (exists
4246: (select null
4247: from per_spinal_point_steps_f psps2
4248: where psps2.effective_end_date >= p_validation_end_date
4249: and psps2.step_id = p_special_ceiling_step_id
4250: and psps2.grade_spine_id = psps.grade_spine_id)));
4251: --

Line 4262: per_spinal_point_steps_f psps

4258: --
4259: cursor csr_valid_step_grade is
4260: select psps.sequence
4261: from per_grade_spines_f pgs,
4262: per_spinal_point_steps_f psps
4263: where psps.step_id = p_special_ceiling_step_id
4264: and pgs.grade_id = p_grade_id
4265: and pgs.grade_spine_id = psps.grade_spine_id
4266: and p_effective_date between pgs.effective_start_date

Line 4276: , per_spinal_point_steps_f psps

4272: select 1
4273: from sys.dual
4274: where exists(select null
4275: from per_spinal_point_placements_f pspp
4276: , per_spinal_point_steps_f psps
4277: , per_grade_spines_f pgs
4278: where pspp.assignment_id = p_assignment_id
4279: and pspp.step_id = psps.step_id
4280: and psps.grade_spine_id=pgs.grade_spine_id