VIEW: APPS.PAYLV_ELEMENT_TYPE_V

Source

View Text - Preformatted

SELECT eltT.ELEMENT_NAME , elt.ELEMENT_TYPE_ID , elt.EFFECTIVE_START_DATE , elt.EFFECTIVE_END_DATE , CASE WHEN ((elt.business_group_id IS NULL AND elt.legislation_code IS NULL) OR (elt.business_group_id IS NULL AND elt.legislation_code = NVL(hr_bis.get_legislation_code,elt.legislation_code)) OR (elt.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, elt.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code, eltT.ELEMENT_NAME order_by, elt.RECALC_EVENT_GROUP_ID FROM pay_element_types_f elt , pay_element_types_f_tl eltT WHERE elt.element_type_id = eltT.element_type_id and eltT.language = userenv('LANG') UNION ALL SELECT null , -1 , hr_general.start_of_time, hr_general.end_of_time, 'Y' , ' ' order_by , -1 FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT ELTT.ELEMENT_NAME
, ELT.ELEMENT_TYPE_ID
, ELT.EFFECTIVE_START_DATE
, ELT.EFFECTIVE_END_DATE
, CASE WHEN ((ELT.BUSINESS_GROUP_ID IS NULL
AND ELT.LEGISLATION_CODE IS NULL) OR (ELT.BUSINESS_GROUP_ID IS NULL
AND ELT.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, ELT.LEGISLATION_CODE)) OR (ELT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ELT.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, ELTT.ELEMENT_NAME ORDER_BY
, ELT.RECALC_EVENT_GROUP_ID
FROM PAY_ELEMENT_TYPES_F ELT
, PAY_ELEMENT_TYPES_F_TL ELTT
WHERE ELT.ELEMENT_TYPE_ID = ELTT.ELEMENT_TYPE_ID
AND ELTT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, 'Y'
, ' ' ORDER_BY
, -1
FROM DUAL WITH READ ONLY