VIEW: APPS.PAYBV_USER_COLUMN_INSTANCE

Source

View Text - Preformatted

SELECT uci.EFFECTIVE_START_DATE ,uci.EFFECTIVE_END_DATE ,uci.VALUE ,uci.LEGISLATION_CODE ,uci.LEGISLATION_SUBGROUP ,uci.USER_COLUMN_INSTANCE_ID ,uci.USER_ROW_ID ,uci.USER_COLUMN_ID ,uci.BUSINESS_GROUP_ID ,uci.LAST_UPDATE_DATE ,uci.LAST_UPDATED_BY ,uci.LAST_UPDATE_LOGIN ,uci.CREATED_BY ,uci.CREATION_DATE ,uci.OBJECT_VERSION_NUMBER ,CASE WHEN ((uci.business_group_id IS NULL AND uci.legislation_code IS NULL) OR (uci.business_group_id IS NULL AND uci.legislation_code = NVL(hr_bis.get_legislation_code,uci.legislation_code)) OR (uci.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, uci.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_user_column_instances_f uci WITH READ ONLY

View Text - HTML Formatted

SELECT UCI.EFFECTIVE_START_DATE
, UCI.EFFECTIVE_END_DATE
, UCI.VALUE
, UCI.LEGISLATION_CODE
, UCI.LEGISLATION_SUBGROUP
, UCI.USER_COLUMN_INSTANCE_ID
, UCI.USER_ROW_ID
, UCI.USER_COLUMN_ID
, UCI.BUSINESS_GROUP_ID
, UCI.LAST_UPDATE_DATE
, UCI.LAST_UPDATED_BY
, UCI.LAST_UPDATE_LOGIN
, UCI.CREATED_BY
, UCI.CREATION_DATE
, UCI.OBJECT_VERSION_NUMBER
, CASE WHEN ((UCI.BUSINESS_GROUP_ID IS NULL
AND UCI.LEGISLATION_CODE IS NULL) OR (UCI.BUSINESS_GROUP_ID IS NULL
AND UCI.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, UCI.LEGISLATION_CODE)) OR (UCI.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, UCI.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_USER_COLUMN_INSTANCES_F UCI WITH READ ONLY