VIEW: APPS.PAYBV_BALANCE_DIMENSION

Source

View Text - Preformatted

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

View Text - HTML Formatted

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