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_HRMS_EXPORT_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 97: FROM PER_PEOPLE_EXTRA_INFO

93:
94: CURSOR c_get_pass_no(p_person_id IN NUMBER)
95: IS
96: SELECT PEI_INFORMATION1 A, PEI_INFORMATION2 B
97: FROM PER_PEOPLE_EXTRA_INFO
98: WHERE PERSON_ID = p_person_id
99: AND INFORMATION_TYPE = 'PER_PASS_INFO_CN'
100: AND PEI_INFORMATION_CATEGORY = 'PER_PASS_INFO_CN'
101: ORDER BY A;

Line 106: FROM PER_PEOPLE_EXTRA_INFO

102:
103: CURSOR c_get_passport_no(p_person_id IN NUMBER)
104: IS
105: SELECT PEI_INFORMATION2
106: FROM PER_PEOPLE_EXTRA_INFO
107: WHERE PERSON_ID = p_person_id
108: AND INFORMATION_TYPE = 'PER_PASSPORT_INFO_CN'
109: AND PEI_INFORMATION_CATEGORY = 'PER_PASSPORT_INFO_CN';
110: