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 1965: FROM per_pay_proposals pp,

1961: FOR UPDATE;
1962: --
1963: CURSOR csr_delete_components IS
1964: SELECT pp.pay_proposal_id
1965: FROM per_pay_proposals pp,
1966: per_assignments_f pa
1967: WHERE pa.person_id = P_PERSON_ID
1968: AND pa.assignment_id = pp.assignment_id
1969: FOR UPDATE;

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

2508: --
2509: begin
2510: --
2511: -- Bug 349818. Delete from per_pay_proposal_components before
2512: -- deleting from the parent record in per_pay_proposals to
2513: -- maintain referential integrity, using the cursor csr_delete_components
2514: -- and the original per_pay_proposals delete.
2515: --
2516: OPEN csr_delete_components;

Line 2514: -- and the original per_pay_proposals delete.

2510: --
2511: -- Bug 349818. Delete from per_pay_proposal_components before
2512: -- deleting from the parent record in per_pay_proposals to
2513: -- maintain referential integrity, using the cursor csr_delete_components
2514: -- and the original per_pay_proposals delete.
2515: --
2516: OPEN csr_delete_components;
2517: LOOP
2518: FETCH csr_delete_components INTO l_proposal_id;

Line 2528: delete from per_pay_proposals p

2524: CLOSE csr_delete_components;
2525: --
2526: -- Now delete the parent proposal record.
2527: --
2528: delete from per_pay_proposals p
2529: where exists (
2530: select null
2531: from per_assignments_f ass
2532: where ass.assignment_id = p.assignment_id