eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAYLV_EVENT_GROUP_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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