APPS.HR_PERSON_DELETE dependencies on PER_PAY_PROPOSAL_COMPONENTS

Line 85: to delete per_pay_proposal_components

81: to moderate_predel_validation procedure.
82: 70.15 10-Jul-96 AMills Bug 349818.
83: Added cursor DELETE_COMPONENTS
84: to procedure delete_a_person
85: to delete per_pay_proposal_components
86: in the case of a multi-component
87: proposal, to maintain referential
88: integrity. The original delete from
89: per_pay_proposals follows as before.

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

1852: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 185);
1853: --
1854: begin
1855: --
1856: -- Bug 349818. Delete from per_pay_proposal_components before
1857: -- deleting from the parent record in per_pay_proposals to
1858: -- maintain referential integrity, using the cursor DELETE_COMPONENTS
1859: -- and the original per_pay_proposals delete.
1860: --

Line 1865: DELETE FROM per_pay_proposal_components

1861: open DELETE_COMPONENTS;
1862: LOOP
1863: FETCH DELETE_COMPONENTS INTO v_proposal_id;
1864: EXIT WHEN DELETE_COMPONENTS%NOTFOUND;
1865: DELETE FROM per_pay_proposal_components
1866: WHERE pay_proposal_id = v_proposal_id;
1867: END LOOP;
1868: close DELETE_COMPONENTS;
1869: --