eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PAY_COST_ALLOCATIONS_F

Line 333: from pay_cost_allocations_f pca

329: for update of spp.assignment_id;
330: --
331: cursor csr_cost_allocations is
332: select pca.rowid
333: from pay_cost_allocations_f pca
334: where exists (select 'x'
335: from per_assignments_f paf
336: where pca.assignment_id = paf.assignment_id
337: and paf.business_group_id + 0 = p_business_group_id

Line 1737: delete from pay_cost_allocations_f pca

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;
1739:
1740: hr_utility.set_location('cancel_emp_apl_hire ',80);
1741: -- Start of fix 3564129

Line 2635: delete from pay_cost_allocations_f pca

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

Line 4989: DELETE FROM pay_cost_allocations_f pca

4985: WHERE spp.assignment_id = assignment1_rec.assignment_id;
4986: --
4987: hr_utility.set_location(l_proc,250);
4988: --
4989: DELETE FROM pay_cost_allocations_f pca
4990: WHERE pca.assignment_id = assignment1_rec.assignment_id;
4991: --
4992: hr_utility.set_location(l_proc,260);
4993: --