DBA Data[Home] [Help]

APPS.HR_PSF_BUS dependencies on PER_GRADE_SPINES_F

Line 712: from per_grade_spines_f pgs,

708: and p_validation_start_date between psps.effective_start_date and psps.effective_end_date;
709: --
710: cursor csr_valid_step_grade is
711: select psps.sequence
712: from per_grade_spines_f pgs,
713: per_spinal_point_steps_f psps
714: where psps.step_id = p_entry_step_id
715: and pgs.grade_id = p_entry_grade_id
716: and pgs.grade_spine_id = psps.grade_spine_id

Line 784: -- per_grade_spines_f

780: hr_utility.set_location(l_proc, 50);
781: end if;
782: --
783: -- Check that entry_step_id exists and is date effective
784: -- per_grade_spines_f
785: --
786: open csr_valid_step;
787: fetch csr_valid_step into l_business_group_id;
788: if csr_valid_step%notfound then