APPS.PER_ASG_BUS2 dependencies on PER_GRADE_SPINES_F

Line 4294: from per_grade_spines_f pgs

4290: and psps2.grade_spine_id = psps.grade_spine_id)));
4291: --
4292: cursor csr_get_bus_grp is
4293: select pgs.business_group_id
4294: from per_grade_spines_f pgs
4295: where pgs.ceiling_step_id = p_special_ceiling_step_id
4296: and p_effective_date between pgs.effective_start_date
4297: and pgs.effective_end_date;
4298: --

Line 4301: from per_grade_spines_f pgs,

4297: and pgs.effective_end_date;
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

Line 4317: , per_grade_spines_f pgs

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
4321: and pgs.grade_id = p_grade_id

Line 4395: -- per_grade_spines_f

4391: end if;
4392: hr_utility.set_location(l_proc, 50);
4393: --
4394: -- Check that special_ceiling_step_id exists and is date effective
4395: -- per_grade_spines_f
4396: --
4397: open csr_valid_step;
4398: fetch csr_valid_step into l_exists;
4399: if csr_valid_step%notfound then