APPS.PER_PRV_BUS dependencies on PER_EVENTS

Line 116: from per_events pev

112: l_dummy varchar2(1);
113: --
114: cursor get_event is
115: select null
116: from per_events pev
117: where pev.event_id = p_event_id;
118: --
119: Begin
120: --

Line 133: -- check if event_id value exists in per_events table

129: and nvl(p_event_id,hr_api.g_number)
130: <> nvl(per_prv_shd.g_old_rec.event_id,hr_api.g_number)
131: or not l_api_updating) then
132: --
133: -- check if event_id value exists in per_events table
134: --
135: open get_event;
136: --
137: fetch get_event into l_dummy;

Line 142: -- raise error as FK does not relate to PK in per_events

138: if get_event%notfound then
139: --
140: close get_event;
141: --
142: -- raise error as FK does not relate to PK in per_events
143: -- table.
144: --
145: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_FK2');
146: --

Line 225: -- raise error as FK does not relate to PK in per_events

221: hr_utility.set_location(l_proc,15);
222: --
223: close get_person;
224: --
225: -- raise error as FK does not relate to PK in per_events
226: -- table.
227: --
228: per_prv_shd.constraint_error('PER_PERFORMANCE_REVIEWS_DT1');
229: --