VIEW: APPS.PAYLV_BALANCE_SETS_V

Source

View Text - Preformatted

SELECT pbs.BALANCE_SET_NAME, pbs.BALANCE_SET_ID, CASE WHEN ((pbs.business_group_id IS NULL AND pbs.legislation_code IS NULL) OR (pbs.business_group_id IS NULL AND pbs.legislation_code = NVL(hr_bis.get_legislation_code,pbs.legislation_code)) OR (pbs.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,pbs.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code, pbs.BALANCE_SET_NAME order_by FROM PAY_BALANCE_SETS pbs UNION ALL SELECT null , -1 , 'Y' , ' ' order_by FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PBS.BALANCE_SET_NAME
, PBS.BALANCE_SET_ID
, CASE WHEN ((PBS.BUSINESS_GROUP_ID IS NULL
AND PBS.LEGISLATION_CODE IS NULL) OR (PBS.BUSINESS_GROUP_ID IS NULL
AND PBS.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PBS.LEGISLATION_CODE)) OR (PBS.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBS.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PBS.BALANCE_SET_NAME ORDER_BY
FROM PAY_BALANCE_SETS PBS UNION ALL SELECT NULL
, -1
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY