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_JP_WRKREG_REPORT_PKG dependencies on HR_LOOKUPS

Line 1085: ,DECODE(PJWREV.GENDER,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code= PJWREV.GENDER)) GENDER

1081: IS
1082: SELECT PJWREV.FULL_NAME_KANA
1083: ,PJWREV.FULL_NAME_KANJI
1084: ,PJWREV.DATE_OF_BIRTH
1085: ,DECODE(PJWREV.GENDER,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'SEX' AND lookup_code= PJWREV.GENDER)) GENDER
1086: ,SUBSTR(PJWREV.POSTAL_CODE,1,3)||NVL2(PJWREV.POSTAL_CODE,'-',' ')|| SUBSTR(PJWREV.POSTAL_CODE,4) POSTAL_CODE -- added by rdarasi for Bug #8814071
1087: ,PJWREV.ADDRESS_LINE1||' '||pjwrev.ADDRESS_LINE2||' '||pjwrev.ADDRESS_LINE3 Address
1088: ,PJWREV.REGION1||PJWREV.REGION2||PJWREV.REGION3 Address_kana
1089: ,PJWREV.KIND_OF_BUSINESS

Line 1092: ,DECODE(PJWREV.TERMINATION_REASON,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'LEAV_REAS' AND lookup_code= PJWREV.TERMINATION_REASON)) TERMINATION_REASON

1088: ,PJWREV.REGION1||PJWREV.REGION2||PJWREV.REGION3 Address_kana
1089: ,PJWREV.KIND_OF_BUSINESS
1090: ,PJWREV.HIRE_DATE
1091: ,PJWREV.TERMINATION_DATE
1092: ,DECODE(PJWREV.TERMINATION_REASON,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'LEAV_REAS' AND lookup_code= PJWREV.TERMINATION_REASON)) TERMINATION_REASON
1093: ,PJWREV.DATE_OF_DEATH
1094: ,PJWREV.EMPLOYEE_NUMBER
1095: ,PJWREV.EFFECTIVE_DATE
1096: FROM per_jp_wrkreg_emp_v PJWREV