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.JA_CN_PS_HRMS_EXPORT_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 153: per_people_extra_info

149: SELECT
150: pei_information1 pei_info1
151: , pei_information2 pei_info2
152: FROM
153: per_people_extra_info
154: WHERE person_id = pn_person_id
155: AND information_type = 'PER_PASS_INFO_CN'
156: AND pei_information_category = 'PER_PASS_INFO_CN'
157: ORDER BY pei_info1;

Line 165: per_people_extra_info

161: IS
162: SELECT
163: pei_information2
164: FROM
165: per_people_extra_info
166: WHERE person_id = pn_person_id
167: AND information_type = 'PER_PASSPORT_INFO_CN'
168: AND pei_information_category = 'PER_PASSPORT_INFO_CN';
169: