APPS.PER_PERUSEOX_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO
Line 458: FROM per_people_extra_info
454: race field is set to 'Yes' */
455: BEGIN
456: SELECT 'Y'
457: INTO l_two_or_more 458: FROM per_people_extra_info 459: WHERE person_id = person_id1
460: AND information_type = 'US_ETHNIC_ORIGIN'
461: AND pei_information7 = 'Y'
462: AND (DECODE(pei_information1, 'Y', 1, 0)