APPS.OTA_LPE_BUS dependencies on PER_ALL_PEOPLE_F

Line 458: FROM PER_ALL_PEOPLE_F

454: l_proc varchar2(72) := g_package|| 'chk_person_id';
455: --
456: CURSOR csr_person_id IS
457: SELECT null
458: FROM PER_ALL_PEOPLE_F
459: WHERE person_id = p_person_id;
460: BEGIN
461: --
462: hr_utility.set_location(' Step:'|| l_proc, 20);

Line 664: l_person_name per_all_people_f.full_name%TYPE;

660: FROM hr_lookups
661: WHERE lookup_type = 'OTA_OBJECT_TYPE'
662: and lookup_code = 'LP';
663:
664: l_person_name per_all_people_f.full_name%TYPE;
665: l_object_type varchar2(240);
666:
667: --
668: BEGIN