[Home] [Help]
106: (in dynamic sql because table
107: may not exist for some clients)
108: 110.6 16-APR-1998 SASmith Change to table from
109: per_assignment_budget_values to
110: per_assignment_budget_values_f. Required
111: as table changed to being a datetrack
112: table.
113: 115.2 12-Jun-98 M Bocutt Added call to maintain_ptu to delete
114: PTU records when person deleted.
1895: --
1896: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 20);
1897: --
1898: begin
1899: delete from per_assignment_budget_values_f a
1900: where a.assignment_id in (
1901: select ass.assignment_id
1902: from per_assignments_f ass
1903: where ass.person_id = P_PERSON_ID);
2811: --
2812: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 6);
2813: --
2814: begin
2815: delete from per_assignment_budget_values_f v
2816: where v.assignment_id = V_ASSIGNMENT_ID;
2817: exception
2818: when NO_DATA_FOUND then null;
2819: end;