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.HR_PERSON_INTERNAL dependencies on PER_PAY_PROPOSALS

Line 1996: FROM per_pay_proposals pp,

1992: FOR UPDATE;
1993: --
1994: CURSOR csr_delete_components IS
1995: SELECT pp.pay_proposal_id
1996: FROM per_pay_proposals pp,
1997: per_assignments_f pa
1998: WHERE pa.person_id = P_PERSON_ID
1999: AND pa.assignment_id = pp.assignment_id
2000: FOR UPDATE;

Line 2565: -- deleting from the parent record in per_pay_proposals to

2561: --
2562: begin
2563: --
2564: -- Bug 349818. Delete from per_pay_proposal_components before
2565: -- deleting from the parent record in per_pay_proposals to
2566: -- maintain referential integrity, using the cursor csr_delete_components
2567: -- and the original per_pay_proposals delete.
2568: --
2569: OPEN csr_delete_components;

Line 2567: -- and the original per_pay_proposals delete.

2563: --
2564: -- Bug 349818. Delete from per_pay_proposal_components before
2565: -- deleting from the parent record in per_pay_proposals to
2566: -- maintain referential integrity, using the cursor csr_delete_components
2567: -- and the original per_pay_proposals delete.
2568: --
2569: OPEN csr_delete_components;
2570: LOOP
2571: FETCH csr_delete_components INTO l_proposal_id;

Line 2581: delete from per_pay_proposals p

2577: CLOSE csr_delete_components;
2578: --
2579: -- Now delete the parent proposal record.
2580: --
2581: delete from per_pay_proposals p
2582: where exists (
2583: select null
2584: from per_assignments_f ass
2585: where ass.assignment_id = p.assignment_id