DBA Data[Home] [Help]

APPS.PER_PERUSE1L_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 257: FROM PER_PEOPLE_EXTRA_INFO PEI

253: */
254: AND HEADQUARTERS = 'N'
255: -- Added for bug#11736960
256: AND EXISTS (SELECT 'X'
257: FROM PER_PEOPLE_EXTRA_INFO PEI
258: WHERE PEI.PERSON_ID = PEO.PERSON_ID
259: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
260: AND (PEI.PEI_INFORMATION1 = 'Y'
261: OR PEI.PEI_INFORMATION2 = 'Y'

Line 398: FROM PER_PEOPLE_EXTRA_INFO PEI

394: */
395: AND HEADQUARTERS = 'N'
396: -- Added for bug#11736960
397: AND EXISTS (SELECT 'X'
398: FROM PER_PEOPLE_EXTRA_INFO PEI
399: WHERE PEI.PERSON_ID = PEO.PERSON_ID
400: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
401: AND (PEI.PEI_INFORMATION1 = 'Y'
402: OR PEI.PEI_INFORMATION2 = 'Y'