APPS.PQH_RHT_BUS dependencies on PER_ALL_POSITIONS

Line 414: from per_all_positions a

410: l_dummy varchar2(1);
411: --
412: cursor c1 is
413: select null
414: from per_all_positions a
415: where a.position_id = p_forwarded_to_position_id;
416: --
417: Begin
418: --

Line 431: -- check if forwarded_to_position_id value exists in per_all_positions table

427: <> nvl(pqh_rht_shd.g_old_rec.forwarded_to_position_id,hr_api.g_number)
428: or not l_api_updating) and
429: p_forwarded_to_position_id is not null then
430: --
431: -- check if forwarded_to_position_id value exists in per_all_positions table
432: --
433: open c1;
434: --
435: fetch c1 into l_dummy;

Line 440: -- raise error as FK does not relate to PK in per_all_positions

436: if c1%notfound then
437: --
438: close c1;
439: --
440: -- raise error as FK does not relate to PK in per_all_positions
441: -- table.
442: --
443: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK3');
444: --

Line 490: from per_all_positions a

486: l_dummy varchar2(1);
487: --
488: cursor c1 is
489: select null
490: from per_all_positions a
491: where a.position_id = p_forwarded_by_position_id;
492: --
493: Begin
494: --

Line 507: -- check if forwarded_by_position_id value exists in per_all_positions table

503: <> nvl(pqh_rht_shd.g_old_rec.forwarded_by_position_id,hr_api.g_number)
504: or not l_api_updating) and
505: p_forwarded_by_position_id is not null then
506: --
507: -- check if forwarded_by_position_id value exists in per_all_positions table
508: --
509: open c1;
510: --
511: fetch c1 into l_dummy;

Line 516: -- raise error as FK does not relate to PK in per_all_positions

512: if c1%notfound then
513: --
514: close c1;
515: --
516: -- raise error as FK does not relate to PK in per_all_positions
517: -- table.
518: --
519: pqh_rht_shd.constraint_error('PQH_ROUTING_HISTORY_FK2');
520: --