APPS.HR_PERSON_INTERNAL dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 134: hr_assignment_set_amendments asa

130: from sys.dual
131: where not exists
132: (select null
133: from per_assignments_f ass,
134: hr_assignment_set_amendments asa
135: where asa.assignment_id = ass.assignment_id
136: and ass.person_id = P_PERSON_ID
137: and asa.include_or_exclude = 'I'
138: and not exists

Line 140: from hr_assignment_set_amendments asa2

136: and ass.person_id = P_PERSON_ID
137: and asa.include_or_exclude = 'I'
138: and not exists
139: (select null
140: from hr_assignment_set_amendments asa2
141: where asa2.assignment_set_id = asa.assignment_set_id
142: and asa2.assignment_id <> asa.assignment_id)
143: );
144: --

Line 3140: -- hr_assignment_set_amendments in weak_predel_validation.

3136: hr_utility.set_location(l_proc, 830);
3137: end if;
3138: --
3139: -- Validation has already been performed against
3140: -- hr_assignment_set_amendments in weak_predel_validation.
3141: --
3142: begin
3143: --
3144: delete from hr_assignment_set_amendments h

Line 3144: delete from hr_assignment_set_amendments h

3140: -- hr_assignment_set_amendments in weak_predel_validation.
3141: --
3142: begin
3143: --
3144: delete from hr_assignment_set_amendments h
3145: where h.assignment_id in
3146: (select ass.assignment_id
3147: from per_assignments_f ass
3148: where ass.person_id = P_PERSON_ID);