APPS.HR_PERSON_INTERNAL dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 2511: -- Bug 349818. Delete from per_pay_proposal_components before

2507: end if;
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: --

Line 2520: DELETE FROM per_pay_proposal_components

2516: OPEN csr_delete_components;
2517: LOOP
2518: FETCH csr_delete_components INTO l_proposal_id;
2519: EXIT WHEN csr_delete_components%NOTFOUND;
2520: DELETE FROM per_pay_proposal_components
2521: WHERE pay_proposal_id = l_proposal_id;
2522: END LOOP;
2523: --
2524: CLOSE csr_delete_components;