VIEW: APPS.GHR_MASS_AWARDS_PREVIEW_V

Source

View Text - Preformatted

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, par.award_salary award_salary 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'

View Text - HTML Formatted

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
, PAR.AWARD_SALARY AWARD_SALARY
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'