APPS.IRC_ISC_BUS dependencies on PER_ALL_PEOPLE_F

Line 514: -- This procedure is used to ensure that object_id exists in PER_ALL_PEOPLE_F

510: -- ----------------------------------------------------------------------------
511: -- {Start Of Comments}
512: --
513: -- Description:
514: -- This procedure is used to ensure that object_id exists in PER_ALL_PEOPLE_F
515: -- as 'PERSON' type when the object_type is 'PERSON'
516: --
517: -- Pre Conditions:
518: --

Line 540: from per_all_people_f ppf

536: l_person_id varchar2(1);
537: --
538: cursor csr_person_id is
539: select null
540: from per_all_people_f ppf
541: where ppf.person_id = p_person_id
542: and trunc(p_effective_date) between ppf.effective_start_date
543: and ppf.effective_end_date;
544: --

Line 553: -- Check that Person_ID(Object_id) exists in per_all_people_f

549: (p_api_name => l_proc
550: ,p_argument => 'PERSON_ID'
551: ,p_argument_value => p_person_id
552: );
553: -- Check that Person_ID(Object_id) exists in per_all_people_f
554: hr_utility.set_location(l_proc,20);
555: open csr_person_id;
556: fetch csr_person_id into l_person_id;
557: hr_utility.set_location(l_proc,30);