APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_COST_ALLOCATIONS_F

Line 165: from pay_cost_allocations_f pca

161: for update of spp.assignment_id;
162: --
163: cursor csr_cost_allocations is
164: select pca.rowid
165: from pay_cost_allocations_f pca
166: where exists (select 'x'
167: from per_assignments_f paf
168: where pca.assignment_id = paf.assignment_id
169: and paf.business_group_id + 0 = p_business_group_id

Line 1687: delete from pay_cost_allocations_f pca

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
1690: open irc_asg_status;
1691: fetch irc_asg_status into l_asg_status_id, l_asg_status_ovn;

Line 3715: DELETE FROM pay_cost_allocations_f pca

3711: WHERE spp.assignment_id = assignment1_rec.assignment_id;
3712: --
3713: hr_utility.set_location(l_proc,250);
3714: --
3715: DELETE FROM pay_cost_allocations_f pca
3716: WHERE pca.assignment_id = assignment1_rec.assignment_id;
3717: --
3718: hr_utility.set_location(l_proc,260);
3719: --