APPS.PER_SPS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 673: -- per_spinal_point_placement_f, per_all_assignments_f and hr_all_positions_f

669: -- ---------------------------------------------------------------------------
670: --
671: -- Description
672: -- This procedure is used to check that there are no values in
673: -- per_spinal_point_placement_f, per_all_assignments_f and hr_all_positions_f
674: --
675: -- Pre Conditions
676: -- None.
677: --

Line 722: from per_all_assignments_f

718: and p_date < effective_end_date;
719: --
720: cursor csr_assignment(p_date date) is
721: select 'X'
722: from per_all_assignments_f
723: where special_ceiling_step_id = p_step_id;
724: -- and p_date < effective_end_date;
725: --
726: cursor csr_position(p_date date) is

Line 781: -- Check on per_all_assignments_f

777: hr_utility.raise_error;
778: end if;
779: --
780: hr_utility.set_location(l_proc, 20);
781: -- Check on per_all_assignments_f
782: open csr_assignment(l_date);
783: fetch csr_assignment into l_exists2;
784: close csr_assignment;
785: if l_exists2 = 'X' then