View: PAYBV_BALANCE_DIMENSION

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

View Text

SELECT PBD.DIMENSION_NAME
, PBD.DATABASE_ITEM_SUFFIX
, HR_BIS.BIS_DECODE_LOOKUP('DIMENSION_TYPE'
, PBD.DIMENSION_TYPE) DIMENSION_TYPE
, PBD.LEGISLATION_CODE
, PBD.LEGISLATION_SUBGROUP
, PBD.DESCRIPTION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBD.PAYMENTS_FLAG) PAYMENTS_FLAG
, PBD.EXPIRY_CHECKING_CODE
, HR_BIS.BIS_DECODE_LOOKUP('EXPIRY_CHECKING_LEVEL'
, PBD.EXPIRY_CHECKING_LEVEL) EXPIRY_CHECKING_LEVEL
, PBD.FEED_CHECKING_CODE
, PBD.FEED_CHECKING_TYPE
, PBD.DIMENSION_LEVEL
, PBD.PERIOD_TYPE
, PBD.DATABASE_ITEM_FUNCTION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PBD.SAVE_RUN_BALANCE_ENABLED) SAVE_RUN_BALANCE_ENABLED
, PBD.START_DATE_CODE
, PBD.DIMENSION_TYPE DIMENSION_TYPE_CODE
, PBD.PAYMENTS_FLAG PAYMENTS_FLAG_CODE
, PBD.EXPIRY_CHECKING_LEVEL EXPIRY_CHECKING_LEVEL_CODE
, PBD.SAVE_RUN_BALANCE_ENABLED SAVE_RUN_BALANCE_ENABLED_CODE
, PBD.BALANCE_DIMENSION_ID
, PBD.BUSINESS_GROUP_ID
, PBD.ASG_ACTION_BALANCE_DIM_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
FROM PAY_BALANCE_DIMENSIONS PBD WITH READ ONLY

Columns