VIEW: HR.PQH_FR_VALIDATIONS#

Source

View Text - Preformatted

select VALIDATION_ID VALIDATION_ID, PENSION_FUND_TYPE_CODE PENSION_FUND_TYPE_CODE, PENSION_FUND_ID PENSION_FUND_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, REQUEST_DATE REQUEST_DATE, COMPLETION_DATE COMPLETION_DATE, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID, PREVIOUSLY_VALIDATED_FLAG PREVIOUSLY_VALIDATED_FLAG, STATUS STATUS, EMPLOYER_AMOUNT EMPLOYER_AMOUNT, EMPLOYER_CURRENCY_CODE EMPLOYER_CURRENCY_CODE, EMPLOYEE_AMOUNT EMPLOYEE_AMOUNT, EMPLOYEE_CURRENCY_CODE EMPLOYEE_CURRENCY_CODE, DEDUCTION_PER_PERIOD DEDUCTION_PER_PERIOD, DEDUCTION_CURRENCY_CODE DEDUCTION_CURRENCY_CODE, PERCENT_OF_SALARY PERCENT_OF_SALARY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PQH_FR_VALIDATIONS"

View Text - HTML Formatted

SELECT VALIDATION_ID VALIDATION_ID
, PENSION_FUND_TYPE_CODE PENSION_FUND_TYPE_CODE
, PENSION_FUND_ID PENSION_FUND_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, REQUEST_DATE REQUEST_DATE
, COMPLETION_DATE COMPLETION_DATE
, PREVIOUS_EMPLOYER_ID PREVIOUS_EMPLOYER_ID
, PREVIOUSLY_VALIDATED_FLAG PREVIOUSLY_VALIDATED_FLAG
, STATUS STATUS
, EMPLOYER_AMOUNT EMPLOYER_AMOUNT
, EMPLOYER_CURRENCY_CODE EMPLOYER_CURRENCY_CODE
, EMPLOYEE_AMOUNT EMPLOYEE_AMOUNT
, EMPLOYEE_CURRENCY_CODE EMPLOYEE_CURRENCY_CODE
, DEDUCTION_PER_PERIOD DEDUCTION_PER_PERIOD
, DEDUCTION_CURRENCY_CODE DEDUCTION_CURRENCY_CODE
, PERCENT_OF_SALARY PERCENT_OF_SALARY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PQH_FR_VALIDATIONS"