APPS.PER_REQ_BUS dependencies on PER_ALL_PEOPLE_F

Line 535: -- PER_ALL_PEOPLE_F and if the effective date is valid.

531: -- p_date_to.
532: --
533: -- Post Success:
534: -- Processing continues if a valid record for person_id exists in
535: -- PER_ALL_PEOPLE_F and if the effective date is valid.
536: --
537: -- Post Failure:
538: -- An application error is raised if the person_id does not exist or is not
539: -- valid at that effective date.

Line 555: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F

551: l_proc varchar2(72) := g_package || 'chk_person_id';
552: l_person_id per_requisitions.person_id%type;
553: l_api_updating boolean;
554: --
555: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F
556: --
557: cursor csr_person_id is
558: select person_id
559: from per_all_people_f

Line 559: from per_all_people_f

555: -- Cursor to check that the person_id exists in PER_ALL_PEOPLE_F
556: --
557: cursor csr_person_id is
558: select person_id
559: from per_all_people_f
560: where person_id = p_person_id
561: and p_date_from between effective_start_date and effective_end_date;
562: --
563: Begin

Line 578: -- Check if the person_id exists in PER_ALL_PEOPLE_F

574: or (NOT l_api_updating)) then
575: --
576: if p_person_id is not NULL then
577: --
578: -- Check if the person_id exists in PER_ALL_PEOPLE_F
579: -- and if the person is valid at this effective date
580: --
581: open csr_person_id;
582: fetch csr_person_id into l_person_id;