APPS.PQH_RHT_BUS dependencies on PQH_ROUTING_LIST_MEMBERS

Line 187: from pqh_routing_list_members a

183: l_dummy varchar2(1);
184: --
185: cursor c1 is
186: select null
187: from pqh_routing_list_members a
188: where a.routing_list_member_id = p_forwarded_to_member_id;
189: --
190: Begin
191: --

Line 204: -- check if forwarded_to_member_id value exists in pqh_routing_list_members table

200: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_member_id,hr_api.g_number)
201: or not l_api_updating) and
202: p_forwarded_to_member_id is not null then
203: --
204: -- check if forwarded_to_member_id value exists in pqh_routing_list_members table
205: --
206: open c1;
207: --
208: fetch c1 into l_dummy;

Line 213: -- raise error as FK does not relate to PK in pqh_routing_list_members

209: if c1%notfound then
210: --
211: close c1;
212: --
213: -- raise error as FK does not relate to PK in pqh_routing_list_members
214: -- table.
215: --
216: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK6');
217: --

Line 263: from pqh_routing_list_members a

259: l_dummy varchar2(1);
260: --
261: cursor c1 is
262: select null
263: from pqh_routing_list_members a
264: where a.routing_list_member_id = p_forwarded_by_member_id;
265: --
266: Begin
267: --

Line 280: -- check if forwarded_by_member_id value exists in pqh_routing_list_members table

276: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_member_id,hr_api.g_number)
277: or not l_api_updating) and
278: p_forwarded_by_member_id is not null then
279: --
280: -- check if forwarded_by_member_id value exists in pqh_routing_list_members table
281: --
282: open c1;
283: --
284: fetch c1 into l_dummy;

Line 289: -- raise error as FK does not relate to PK in pqh_routing_list_members

285: if c1%notfound then
286: --
287: close c1;
288: --
289: -- raise error as FK does not relate to PK in pqh_routing_list_members
290: -- table.
291: --
292: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK5');
293: --