APPS.PER_FR_D2_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 605: from per_people_extra_info

601: -- get hours training
602: --
603: select nvl(max(fnd_number.canonical_to_number(pei_information2)),0)
604: into p_hours_training
605: from per_people_extra_info
606: where person_id = p_person_id
607: and nvl(pei_information_category,' ') = 'FR_PROF_TRAIN'
608: and nvl(pei_information1,' ') = to_char(p_year);
609: --