APPS.HR_PERSON_INTERNAL dependencies on PER_PAY_PROPOSAL_COMPONENTS

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

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

Line 2573: DELETE FROM per_pay_proposal_components

2569: OPEN csr_delete_components;
2570: LOOP
2571: FETCH csr_delete_components INTO l_proposal_id;
2572: EXIT WHEN csr_delete_components%NOTFOUND;
2573: DELETE FROM per_pay_proposal_components
2574: WHERE pay_proposal_id = l_proposal_id;
2575: END LOOP;
2576: --
2577: CLOSE csr_delete_components;