VIEW: HR.PAY_IE_SOCIAL_BENEFITS_F#

Source

View Text - Preformatted

select SOCIAL_BENEFIT_ID SOCIAL_BENEFIT_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ASSIGNMENT_ID ASSIGNMENT_ID, ABSENCE_START_DATE ABSENCE_START_DATE, ABSENCE_END_DATE ABSENCE_END_DATE, BENEFIT_AMOUNT BENEFIT_AMOUNT, BENEFIT_TYPE BENEFIT_TYPE, CALCULATION_OPTION CALCULATION_OPTION, REDUCED_TAX_CREDIT REDUCED_TAX_CREDIT, REDUCED_STANDARD_CUTOFF REDUCED_STANDARD_CUTOFF, INCIDENT_ID INCIDENT_ID, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "HR"."PAY_IE_SOCIAL_BENEFITS_F"

View Text - HTML Formatted

SELECT SOCIAL_BENEFIT_ID SOCIAL_BENEFIT_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASSIGNMENT_ID ASSIGNMENT_ID
, ABSENCE_START_DATE ABSENCE_START_DATE
, ABSENCE_END_DATE ABSENCE_END_DATE
, BENEFIT_AMOUNT BENEFIT_AMOUNT
, BENEFIT_TYPE BENEFIT_TYPE
, CALCULATION_OPTION CALCULATION_OPTION
, REDUCED_TAX_CREDIT REDUCED_TAX_CREDIT
, REDUCED_STANDARD_CUTOFF REDUCED_STANDARD_CUTOFF
, INCIDENT_ID INCIDENT_ID
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "HR"."PAY_IE_SOCIAL_BENEFITS_F"