DBA Data[Home] [Help]

VIEW: APPS.HR_H2PI_ELEMENT_TYPES_V

Source

View Text - Preformatted

SELECT et. last_update_date, et. element_type_id, et.business_group_id, et.legislation_code, et.element_name, et. processing_type, et. effective_start_date, et. effective_end_date from pay_element_types_f et WHERE et.attribute20 = 'Y'
View Text - HTML Formatted

SELECT ET. LAST_UPDATE_DATE
, ET. ELEMENT_TYPE_ID
, ET.BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
, ET.ELEMENT_NAME
, ET. PROCESSING_TYPE
, ET. EFFECTIVE_START_DATE
, ET. EFFECTIVE_END_DATE
FROM PAY_ELEMENT_TYPES_F ET
WHERE ET.ATTRIBUTE20 = 'Y'