VIEW: APPS.PAYLV_BALANCE_TYPE_V

Source

View Text - Preformatted

SELECT pbtT.BALANCE_NAME ,pbt.BALANCE_TYPE_ID ,CASE WHEN ((pbt.business_group_id IS NULL AND pbt.legislation_code IS NULL) OR (pbt.business_group_id IS NULL AND pbt.legislation_code = NVL(hr_bis.get_legislation_code,pbt.legislation_code)) OR (pbt.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pbt.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code, pbtT.BALANCE_NAME order_by FROM pay_balance_types pbt ,pay_balance_types_tl pbtT WHERE pbt.balance_type_id = pbtT.balance_type_id and pbtT.language = userenv('LANG') UNION ALL SELECT null ,-1 ,'Y' ,' ' order_by FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT PBTT.BALANCE_NAME
, PBT.BALANCE_TYPE_ID
, CASE WHEN ((PBT.BUSINESS_GROUP_ID IS NULL
AND PBT.LEGISLATION_CODE IS NULL) OR (PBT.BUSINESS_GROUP_ID IS NULL
AND PBT.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PBT.LEGISLATION_CODE)) OR (PBT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PBT.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, PBTT.BALANCE_NAME ORDER_BY
FROM PAY_BALANCE_TYPES PBT
, PAY_BALANCE_TYPES_TL PBTT
WHERE PBT.BALANCE_TYPE_ID = PBTT.BALANCE_TYPE_ID
AND PBTT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY