APPS.PER_RAA_BUS dependencies on PER_ALL_PEOPLE_F

Line 447: -- PER_ALL_PEOPLE_F and system person type is EMP or CWK.

443: -- -----------------------------------------------------------------------------
444: --
445: -- Description:
446: -- Checks that Authorising person id exists in
447: -- PER_ALL_PEOPLE_F and system person type is EMP or CWK.
448: --
449: -- Prerequisites:
450: -- g_old_rec has been populated with details of the values currently in
451: -- the database.

Line 488: select null from PER_ALL_PEOPLE_F pap

484: l_system_person_type varchar2(1);
485: l_api_updating boolean;
486:
487: cursor csr_authorising_person_id is
488: select null from PER_ALL_PEOPLE_F pap
489: where pap.person_id = p_authorising_person_id
490: and
491: (p_date_start between pap.effective_start_date and pap.effective_end_date);
492:

Line 514: -- check that authorising_person_id exists in per_all_people_f.

510: p_authorising_person_id <>
511: NVL(per_raa_shd.g_old_rec.authorising_person_id,hr_api.g_number)
512: ) or (NOT l_api_updating) then
513:
514: -- check that authorising_person_id exists in per_all_people_f.
515: hr_utility.set_location(l_proc,30);
516: open csr_authorising_person_id;
517: fetch csr_authorising_person_id into l_authorising_person_id;
518: if csr_authorising_person_id%NOTFOUND then

Line 608: -- check that run_by_organization_id exists in per_all_people_f.

604: p_run_by_organization_id <>
605: NVL(per_raa_shd.g_old_rec.run_by_organization_id,hr_api.g_number))
606: or (NOT l_api_updating) then
607:
608: -- check that run_by_organization_id exists in per_all_people_f.
609: hr_utility.set_location(l_proc,30);
610: open csr_run_by_organization_id;
611: fetch csr_run_by_organization_id into l_run_by_organization_id;
612: if csr_run_by_organization_id%NOTFOUND then

Line 641: -- PER_ALL_PEOPLE_F and system person type is EMP or CWK.

637: -- -----------------------------------------------------------------------------
638: --
639: -- Description:
640: -- Checks that internal contact person id exists in
641: -- PER_ALL_PEOPLE_F and system person type is EMP or CWK.
642: --
643: -- Prerequisites:
644: -- g_old_rec has been populated with details of the values currently in
645: -- the database.

Line 682: select null from PER_ALL_PEOPLE_F pap

678: l_system_person_type varchar2(1);
679: l_api_updating boolean;
680:
681: cursor csr_internal_contact_person_id is
682: select null from PER_ALL_PEOPLE_F pap
683: where pap.person_id = p_internal_contact_person_id
684: and
685: (p_date_start between pap.effective_start_date and pap.effective_end_date);
686:

Line 709: -- check that internal_contact_person_id exists in per_all_people_f.

705: p_internal_contact_person_id <>
706: NVL(per_raa_shd.g_old_rec.internal_contact_person_id,hr_api.g_number))
707: or (NOT l_api_updating) then
708:
709: -- check that internal_contact_person_id exists in per_all_people_f.
710: hr_utility.set_location(l_proc,30);
711: open csr_internal_contact_person_id;
712: fetch csr_internal_contact_person_id into l_internal_contact_person_id;
713: if csr_internal_contact_person_id%NOTFOUND then