VIEW: HR.HR_S_BENEFIT_CLASSIFICATIONS#

Source

View Text - Preformatted

select BENEFIT_CLASSIFICATION_ID BENEFIT_CLASSIFICATION_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LEGISLATION_CODE LEGISLATION_CODE, ACTIVE_FLAG ACTIVE_FLAG, BENEFICIARY_ALLOWED_FLAG BENEFICIARY_ALLOWED_FLAG, BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME, BENEFIT_CLASSIFICATION_TYPE BENEFIT_CLASSIFICATION_TYPE, CHARGEABLE_FLAG CHARGEABLE_FLAG, COBRA_FLAG COBRA_FLAG, CONTRIBUTIONS_USED CONTRIBUTIONS_USED, DEPENDENTS_ALLOWED_FLAG DEPENDENTS_ALLOWED_FLAG, DFLT_POST_TERMINATION_RULE DFLT_POST_TERMINATION_RULE, DFLT_PROCESSING_TYPE DFLT_PROCESSING_TYPE, BEN_CLASS_PROCESSING_RULE BEN_CLASS_PROCESSING_RULE, 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, COMMENTS COMMENTS from "HR"."HR_S_BENEFIT_CLASSIFICATIONS"

View Text - HTML Formatted

SELECT BENEFIT_CLASSIFICATION_ID BENEFIT_CLASSIFICATION_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LEGISLATION_CODE LEGISLATION_CODE
, ACTIVE_FLAG ACTIVE_FLAG
, BENEFICIARY_ALLOWED_FLAG BENEFICIARY_ALLOWED_FLAG
, BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME
, BENEFIT_CLASSIFICATION_TYPE BENEFIT_CLASSIFICATION_TYPE
, CHARGEABLE_FLAG CHARGEABLE_FLAG
, COBRA_FLAG COBRA_FLAG
, CONTRIBUTIONS_USED CONTRIBUTIONS_USED
, DEPENDENTS_ALLOWED_FLAG DEPENDENTS_ALLOWED_FLAG
, DFLT_POST_TERMINATION_RULE DFLT_POST_TERMINATION_RULE
, DFLT_PROCESSING_TYPE DFLT_PROCESSING_TYPE
, BEN_CLASS_PROCESSING_RULE BEN_CLASS_PROCESSING_RULE
, 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
, COMMENTS COMMENTS
FROM "HR"."HR_S_BENEFIT_CLASSIFICATIONS"