View: PAYLV_EVENT_GROUP_V

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

View Text

SELECT PEG.EVENT_GROUP_NAME
, PEG.EVENT_GROUP_ID
, CASE WHEN ((PEG.BUSINESS_GROUP_ID IS NULL
AND PEG.LEGISLATION_CODE IS NULL) OR (PEG.BUSINESS_GROUP_ID IS NULL
AND PEG.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PEG.LEGISLATION_CODE)) OR (PEG.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PEG.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PEG.EVENT_GROUP_NAME ORDER_BY
, PEG.EVENT_GROUP_TYPE
FROM PAY_EVENT_GROUPS PEG UNION ALL SELECT NULL
, -1
, 'Y'
, ' ' ORDER_BY
, NULL
FROM DUAL WITH READ ONLY

Columns