APPS.PER_ASG_BUS2 dependencies on PER_GRADE_SPINES_F

Line 4254: from per_grade_spines_f pgs

4250: and psps2.grade_spine_id = psps.grade_spine_id)));
4251: --
4252: cursor csr_get_bus_grp is
4253: select pgs.business_group_id
4254: from per_grade_spines_f pgs
4255: where pgs.ceiling_step_id = p_special_ceiling_step_id
4256: and p_effective_date between pgs.effective_start_date
4257: and pgs.effective_end_date;
4258: --

Line 4261: from per_grade_spines_f pgs,

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

Line 4277: , per_grade_spines_f pgs

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

Line 4355: -- per_grade_spines_f

4351: end if;
4352: hr_utility.set_location(l_proc, 50);
4353: --
4354: -- Check that special_ceiling_step_id exists and is date effective
4355: -- per_grade_spines_f
4356: --
4357: open csr_valid_step;
4358: fetch csr_valid_step into l_exists;
4359: if csr_valid_step%notfound then