DBA Data[Home] [Help]

VIEW: HR.HR_H2PI_ELEMENT_TYPES#

Source

View Text - Preformatted

select LAST_UPD_DATE LAST_UPD_DATE, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CLIENT_ID CLIENT_ID, LEGISLATION_CODE LEGISLATION_CODE, ELEMENT_NAME ELEMENT_NAME, PROCESSING_TYPE PROCESSING_TYPE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, STATUS STATUS from "HR"."HR_H2PI_ELEMENT_TYPES"
View Text - HTML Formatted

SELECT LAST_UPD_DATE LAST_UPD_DATE
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CLIENT_ID CLIENT_ID
, LEGISLATION_CODE LEGISLATION_CODE
, ELEMENT_NAME ELEMENT_NAME
, PROCESSING_TYPE PROCESSING_TYPE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, STATUS STATUS
FROM "HR"."HR_H2PI_ELEMENT_TYPES"