Product: | GHR - US Federal Human Resources |
---|---|
Description: | This view holds the Mass Award Preview Information. |
Implementation/DBA Data: | APPS.GHR_MASS_AWARDS_PREVIEW_V |
SELECT PAR.MASS_ACTION_ID MASS_AWARD_ID
, PAR.PA_REQUEST_ID PA_REQUEST_ID
, PAR.PERSON_ID PERSON_ID
, PAR.EFFECTIVE_DATE EFFECTIVE_DATE
, PAR.MASS_ACTION_SELECT_FLAG SELECT_FLAG
, PAR.EMPLOYEE_LAST_NAME EMPLOYEE_LAST_NAME
, PAR.EMPLOYEE_FIRST_NAME EMPLOYEE_FIRST_NAME
, PAR.EMPLOYEE_MIDDLE_NAMES EMPLOYEE_MIDDLE_NAMES
, PAR.EMPLOYEE_NATIONAL_IDENTIFIER EMPLOYEE_NATIONAL_IDENTIFIER
, PAR.AWARD_AMOUNT AWARD_AMOUNT
, PAR.AWARD_UOM AWARD_UOM
, PAR.AWARD_PERCENTAGE AWARD_PERCENTAGE
, REI.REI_INFORMATION3 AWARD_AGENCY_CODE
, REI.REI_INFORMATION4 AWARD_TYPE
, REI.REI_INFORMATION6 GROUP_AWARD_ID
, REI.REI_INFORMATION7 TANGIBLE_BENEFIT_DOLLARS
, REI.REI_INFORMATION9 DATE_AWARD_EARNED
, PAR.FROM_BASIC_PAY BASIC_PAY
, PAR.TO_ORGANIZATION_ID ORGANIZATION_ID
, PAR.DUTY_STATION_CODE DUTY_STATION_CODE
, PAR.DUTY_STATION_DESC DUTY_STATION_DESC
, PAR.AGENCY_CODE AGENCY_CODE
, PAR.EMPLOYEE_DEPT_OR_AGENCY AGENCY_CODE_DESC
, PAR.PERSONNEL_OFFICE_ID POI
, PAR.POSITION_OCCUPIED POSITION_OCCUPIED
, PAR.FROM_POSITION_TITLE POSITION_TITLE
, PAR.FROM_PAY_PLAN PAY_PLAN
, PAR.FROM_GRADE_OR_LEVEL GRADE_OR_LEVEL
, PAR.FROM_OCC_CODE OCC_CODE
, PAR.FROM_OFFICE_SYMBOL OFFICE_SYMBOL
, PAR.MASS_ACTION_COMMENTS COMMENTS
FROM GHR_PA_REQUESTS PAR
, GHR_PA_REQUEST_EXTRA_INFO REI
WHERE PAR.MASS_ACTION_ID IS NOT NULL
AND PAR.PERSON_ID IS NOT NULL
AND NVL(PAR.RPA_TYPE
, '$') = 'A'
AND PAR.PA_NOTIFICATION_ID IS NULL
AND REI.PA_REQUEST_ID(+) = PAR.PA_REQUEST_ID
AND REI.INFORMATION_TYPE(+) = 'GHR_US_PAR_AWARDS_BONUS'