eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSEO1_XMLP_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 581: FROM PER_PEOPLE_EXTRA_INFO PEI

577: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )
578: */
579: -- Added for bug#11736960
580: AND EXISTS (SELECT 'X'
581: FROM PER_PEOPLE_EXTRA_INFO PEI
582: WHERE PEI.PERSON_ID = PEO.PERSON_ID
583: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
584: AND (PEI.PEI_INFORMATION1 = 'Y'
585: OR PEI.PEI_INFORMATION2 = 'Y'

Line 839: FROM PER_PEOPLE_EXTRA_INFO PEI

835: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )
836: */
837: -- Added for bug#11736960
838: AND EXISTS (SELECT 'X'
839: FROM PER_PEOPLE_EXTRA_INFO PEI
840: WHERE PEI.PERSON_ID = PEO.PERSON_ID
841: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
842: AND (PEI.PEI_INFORMATION1 = 'Y'
843: OR PEI.PEI_INFORMATION2 = 'Y'

Line 1018: FROM PER_PEOPLE_EXTRA_INFO PEI

1014: WHERE HIERARCHY_VERSION_ID = P_HIERARCHY_VERSION_ID )
1015: */
1016: -- Added for bug#11736960
1017: AND EXISTS (SELECT 'X'
1018: FROM PER_PEOPLE_EXTRA_INFO PEI
1019: WHERE PEI.PERSON_ID = PEO.PERSON_ID
1020: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
1021: AND (PEI.PEI_INFORMATION1 = 'Y'
1022: OR PEI.PEI_INFORMATION2 = 'Y'

Line 1344: FROM PER_PEOPLE_EXTRA_INFO PEI

1340: AND PGN.NODE_TYPE in ( 'EST' , 'LOC' ) )
1341: */
1342: -- Added for bug#11736960
1343: AND EXISTS (SELECT 'X'
1344: FROM PER_PEOPLE_EXTRA_INFO PEI
1345: WHERE PEI.PERSON_ID = PEO.PERSON_ID
1346: AND PEI.INFORMATION_TYPE = 'US_ETHNIC_ORIGIN'
1347: AND (PEI.PEI_INFORMATION1 = 'Y'
1348: OR PEI.PEI_INFORMATION2 = 'Y'