APPS.OTA_CRE_BUS dependencies on PER_ALL_PEOPLE_F

Line 385: FROM PER_ALL_PEOPLE_F

381: l_proc varchar2(72) := g_package|| 'chk_person_id';
382: --
383: CURSOR csr_person_id IS
384: SELECT null
385: FROM PER_ALL_PEOPLE_F
386: WHERE person_id = p_person_id;
387: BEGIN
388: --
389: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 566: l_person_name per_all_people_f.full_name%TYPE;

562: FROM hr_lookups
563: WHERE lookup_type = 'OTA_OBJECT_TYPE'
564: and lookup_code = 'CRT';
565:
566: l_person_name per_all_people_f.full_name%TYPE;
567: l_object_type varchar2(240);
568:
569: --
570: BEGIN