APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 154: from per_spinal_point_placements_f spp

150: for update of pgr.grade_or_spinal_point_id;
151: --
152: cursor csr_grade_steps is
153: select spp.rowid
154: from per_spinal_point_placements_f spp
155: where spp.business_group_id = p_business_group_id and
156: exists (select 'x'
157: from per_assignments_f paf
158: where spp.assignment_id = paf.assignment_id

Line 1685: delete from per_spinal_point_placements_f spp

1681: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',240);
1682: fetch assignments into p_rowid,l_assignment_id,l_asg_status_type_id; -- Bug 3564129
1683: exit when assignments%NOTFOUND;
1684: -- VT #438579 03/05/97 added delete
1685: delete from per_spinal_point_placements_f spp
1686: where spp.assignment_id = l_assignment_id;
1687: delete from pay_cost_allocations_f pca
1688: where pca.assignment_id = l_assignment_id;
1689: -- Start of fix 3564129

Line 3710: DELETE FROM per_spinal_point_placements_f spp

3706: FOR assignment1_rec IN csr_assignments1 LOOP
3707: --
3708: hr_utility.set_location(l_proc,240);
3709: --
3710: DELETE FROM per_spinal_point_placements_f spp
3711: WHERE spp.assignment_id = assignment1_rec.assignment_id;
3712: --
3713: hr_utility.set_location(l_proc,250);
3714: --