VIEW: APPS.PAYLV_BALANCE_DIMENSION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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