APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 322: from per_spinal_point_placements_f spp

318: for update of pgr.grade_or_spinal_point_id;
319: --
320: cursor csr_grade_steps is
321: select spp.rowid
322: from per_spinal_point_placements_f spp
323: where spp.business_group_id = p_business_group_id and
324: exists (select 'x'
325: from per_assignments_f paf
326: where spp.assignment_id = paf.assignment_id

Line 1734: delete from per_spinal_point_placements_f spp

1730: hr_utility.set_location('cancel_emp_apl_hire ',70);
1731:
1732: -- VT #438579 03/05/97 added delete
1733:
1734: delete from per_spinal_point_placements_f spp
1735: where spp.assignment_id = l_assignment_id;
1736:
1737: delete from pay_cost_allocations_f pca
1738: where pca.assignment_id = l_assignment_id;

Line 2633: delete from per_spinal_point_placements_f spp

2629: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire',240);
2630: fetch assignments into p_rowid,l_assignment_id,l_asg_status_type_id; -- Bug 3564129
2631: exit when assignments%NOTFOUND;
2632: -- VT #438579 03/05/97 added delete
2633: delete from per_spinal_point_placements_f spp
2634: where spp.assignment_id = l_assignment_id;
2635: delete from pay_cost_allocations_f pca
2636: where pca.assignment_id = l_assignment_id;
2637: -- Start of fix 3564129

Line 4984: DELETE FROM per_spinal_point_placements_f spp

4980: FOR assignment1_rec IN csr_assignments1 LOOP
4981: --
4982: hr_utility.set_location(l_proc,240);
4983: --
4984: DELETE FROM per_spinal_point_placements_f spp
4985: WHERE spp.assignment_id = assignment1_rec.assignment_id;
4986: --
4987: hr_utility.set_location(l_proc,250);
4988: --