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'
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'
|
|
|