VIEW: HR.PAY_PL_PAYE_DETAILS_F#

Source

View Text - Preformatted

select PAYE_DETAILS_ID PAYE_DETAILS_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, PER_OR_ASG_ID PER_OR_ASG_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CONTRACT_CATEGORY CONTRACT_CATEGORY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TAX_REDUCTION TAX_REDUCTION, TAX_CALC_WITH_SPOUSE_CHILD TAX_CALC_WITH_SPOUSE_CHILD, INCOME_REDUCTION INCOME_REDUCTION, INCOME_REDUCTION_AMOUNT INCOME_REDUCTION_AMOUNT, RATE_OF_TAX RATE_OF_TAX, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "HR"."PAY_PL_PAYE_DETAILS_F"

View Text - HTML Formatted

SELECT PAYE_DETAILS_ID PAYE_DETAILS_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PER_OR_ASG_ID PER_OR_ASG_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CONTRACT_CATEGORY CONTRACT_CATEGORY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TAX_REDUCTION TAX_REDUCTION
, TAX_CALC_WITH_SPOUSE_CHILD TAX_CALC_WITH_SPOUSE_CHILD
, INCOME_REDUCTION INCOME_REDUCTION
, INCOME_REDUCTION_AMOUNT INCOME_REDUCTION_AMOUNT
, RATE_OF_TAX RATE_OF_TAX
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "HR"."PAY_PL_PAYE_DETAILS_F"