APPS.PER_SPS_BUS dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 716: from per_spinal_point_placements_f

712: l_exists3 varchar2(1) := Null;
713: --
714: cursor csr_spinal_point(p_date date) is
715: select 'X'
716: from per_spinal_point_placements_f
717: where step_id = p_step_id
718: and p_date < effective_end_date;
719: --
720: cursor csr_assignment(p_date date) is

Line 771: -- Check on per_spinal_point_placements_f

767: l_date := p_effective_date;
768: else
769: l_date := hr_api.g_eot;
770: end if;
771: -- Check on per_spinal_point_placements_f
772: open csr_spinal_point(l_date);
773: fetch csr_spinal_point into l_exists1;
774: close csr_spinal_point;
775: if l_exists1 = 'X' then