DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 110: per_assignment_budget_values_f. Required

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.

Line 1970: delete from per_assignment_budget_values_f a

1966: --
1967: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 20);
1968: --
1969: begin
1970: delete from per_assignment_budget_values_f a
1971: where a.assignment_id in (
1972: select ass.assignment_id
1973: from per_assignments_f ass
1974: where ass.person_id = P_PERSON_ID);

Line 2887: delete from per_assignment_budget_values_f v

2883: --
2884: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 6);
2885: --
2886: begin
2887: delete from per_assignment_budget_values_f v
2888: where v.assignment_id = V_ASSIGNMENT_ID;
2889: exception
2890: when NO_DATA_FOUND then null;
2891: end;