View: PAYLV_ELEMENT_TYPE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYLV_ELEMENT_TYPE_V

View Text

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

Columns