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.GHR_GEN_RPA_NPA dependencies on GHR_UPD_HR_VALIDATION

Line 31: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE

27: ,EMPLOYEE_FIRST_NAME
28: ,NVL(EMPLOYEE_MIDDLE_NAMES, '') EMPLOYEE_MIDDLE_NAME
29: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
30: ,EMPLOYEE_DATE_OF_BIRTH
31: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
32: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, 2, 3), FIRST_NOA_CODE) FIRST_NOA_CODE
33: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE
34: ,FIRST_NOA_DESC
35: ,FIRST_ACTION_LA_CODE1

Line 1404: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE

1400: NVL(EMPLOYEE_MIDDLE_NAMES, 'NMN') EMPLOYEE_MIDDLE_NAME
1401: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
1402: ,EMPLOYEE_DATE_OF_BIRTH
1403: ,EMPLOYEE_ASSIGNMENT_ID
1404: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
1405: ,NOA_FAMILY_CODE
1406: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, -3), FIRST_NOA_CODE) FIRST_NOA_CODE
1407: ,FIRST_NOA_DESC
1408: ,FIRST_ACTION_LA_CODE1