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 1927: -- Bug 349818. Delete from per_pay_proposal_components before

1923: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 185);
1924: --
1925: begin
1926: --
1927: -- Bug 349818. Delete from per_pay_proposal_components before
1928: -- deleting from the parent record in per_pay_proposals to
1929: -- maintain referential integrity, using the cursor DELETE_COMPONENTS
1930: -- and the original per_pay_proposals delete.
1931: --

Line 1936: DELETE FROM per_pay_proposal_components

1932: open DELETE_COMPONENTS;
1933: LOOP
1934: FETCH DELETE_COMPONENTS INTO v_proposal_id;
1935: EXIT WHEN DELETE_COMPONENTS%NOTFOUND;
1936: DELETE FROM per_pay_proposal_components
1937: WHERE pay_proposal_id = v_proposal_id;
1938: END LOOP;
1939: close DELETE_COMPONENTS;
1940: --