APPS.GHR_GEN_RPA_NPA dependencies on GHR_UPD_HR_VALIDATION

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

73: ,EMPLOYEE_FIRST_NAME
74: ,NVL(EMPLOYEE_MIDDLE_NAMES, '') EMPLOYEE_MIDDLE_NAME
75: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
76: ,EMPLOYEE_DATE_OF_BIRTH
77: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
78: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, 2, 3), FIRST_NOA_CODE) FIRST_NOA_CODE
79: ,GHR_PA_REQUESTS.NOA_FAMILY_CODE
80: ,FIRST_NOA_DESC
81: ,FIRST_ACTION_LA_CODE1

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

1631: NVL(EMPLOYEE_MIDDLE_NAMES, 'NMN') EMPLOYEE_MIDDLE_NAME
1632: ,EMPLOYEE_NATIONAL_IDENTIFIER SS_NUMBER
1633: ,EMPLOYEE_DATE_OF_BIRTH
1634: ,EMPLOYEE_ASSIGNMENT_ID
1635: ,NVL(GHR_UPD_HR_VALIDATION.GET_EXEMP_AWARD_DATE(PA_REQUEST_ID),EFFECTIVE_DATE) EFFECTIVE_DATE
1636: ,NOA_FAMILY_CODE
1637: ,DECODE(LENGTH(NVL(FIRST_NOA_CODE, '')), 4, SUBSTR(FIRST_NOA_CODE, -3), FIRST_NOA_CODE) FIRST_NOA_CODE
1638: ,FIRST_NOA_DESC
1639: ,FIRST_ACTION_LA_CODE1