VIEW: APPS.PAYBV_USER_COLUMN

Source

View Text - Preformatted

SELECT puc.USER_COLUMN_NAME ,puc.LEGISLATION_CODE ,puc.LEGISLATION_SUBGROUP ,puc.USER_COLUMN_ID ,puc.USER_TABLE_ID ,puc.FORMULA_ID ,puc.BUSINESS_GROUP_ID ,puc.LAST_UPDATE_DATE ,puc.LAST_UPDATED_BY ,puc.LAST_UPDATE_LOGIN ,puc.CREATED_BY ,puc.CREATION_DATE ,puc.OBJECT_VERSION_NUMBER ,CASE WHEN ((puc.business_group_id IS NULL AND puc.legislation_code IS NULL) OR (puc.business_group_id IS NULL AND puc.legislation_code = NVL(hr_bis.get_legislation_code,puc.legislation_code)) OR (puc.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, puc.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_user_columns puc WITH READ ONLY

View Text - HTML Formatted

SELECT PUC.USER_COLUMN_NAME
, PUC.LEGISLATION_CODE
, PUC.LEGISLATION_SUBGROUP
, PUC.USER_COLUMN_ID
, PUC.USER_TABLE_ID
, PUC.FORMULA_ID
, PUC.BUSINESS_GROUP_ID
, PUC.LAST_UPDATE_DATE
, PUC.LAST_UPDATED_BY
, PUC.LAST_UPDATE_LOGIN
, PUC.CREATED_BY
, PUC.CREATION_DATE
, PUC.OBJECT_VERSION_NUMBER
, CASE WHEN ((PUC.BUSINESS_GROUP_ID IS NULL
AND PUC.LEGISLATION_CODE IS NULL) OR (PUC.BUSINESS_GROUP_ID IS NULL
AND PUC.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PUC.LEGISLATION_CODE)) OR (PUC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUC.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_USER_COLUMNS PUC WITH READ ONLY