View: PAYLV_BALANCE_TYPE_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAYLV_BALANCE_TYPE_V

View Text

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

Columns