VIEW: APPS.PAYBV_EVENT_GROUP_V

Source

View Text - Preformatted

SELECT PEG.EVENT_GROUP_NAME ,hr_bis.bis_decode_lookup('EVENT_GROUP_TYPE', PEG.EVENT_GROUP_TYPE) EVENT_GROUP_TYPE_M ,hr_bis.bis_decode_lookup('PRORATION_PERIOD_TYPE', PEG.PRORATION_TYPE) PRORATION_TYPE_M ,PEG.EVENT_GROUP_TYPE ,PEG.PRORATION_TYPE ,PEG.LEGISLATION_CODE ,PEG.BUSINESS_GROUP_ID ,PEG.EVENT_GROUP_ID ,PEG.CREATION_DATE ,PEG.CREATED_BY ,PEG.LAST_UPDATE_DATE ,PEG.LAST_UPDATE_LOGIN ,PEG.LAST_UPDATED_BY ,PEG.OBJECT_VERSION_NUMBER ,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 FROM PAY_EVENT_GROUPS PEG WITH READ ONLY

View Text - HTML Formatted

SELECT PEG.EVENT_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('EVENT_GROUP_TYPE'
, PEG.EVENT_GROUP_TYPE) EVENT_GROUP_TYPE_M
, HR_BIS.BIS_DECODE_LOOKUP('PRORATION_PERIOD_TYPE'
, PEG.PRORATION_TYPE) PRORATION_TYPE_M
, PEG.EVENT_GROUP_TYPE
, PEG.PRORATION_TYPE
, PEG.LEGISLATION_CODE
, PEG.BUSINESS_GROUP_ID
, PEG.EVENT_GROUP_ID
, PEG.CREATION_DATE
, PEG.CREATED_BY
, PEG.LAST_UPDATE_DATE
, PEG.LAST_UPDATE_LOGIN
, PEG.LAST_UPDATED_BY
, PEG.OBJECT_VERSION_NUMBER
, 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
FROM PAY_EVENT_GROUPS PEG WITH READ ONLY