VIEW: APPS.PAYBV_USER_TABLE

Source

View Text - Preformatted

SELECT put.USER_TABLE_NAME ,hr_bis.bis_decode_lookup('RANGE_MATCH', put.RANGE_OR_MATCH) RANGE_OR_MATCH ,hr_bis.bis_decode_lookup('DATA_TYPE', put.USER_KEY_UNITS) USER_KEY_UNITS ,put.USER_ROW_TITLE ,put.LEGISLATION_CODE ,put.LEGISLATION_SUBGROUP ,put.RANGE_OR_MATCH RANGE_OR_MATCH_CODE ,put.USER_KEY_UNITS USER_KEY_UNITS_CODE ,put.USER_TABLE_ID ,put.BUSINESS_GROUP_ID ,put.LAST_UPDATE_DATE ,put.LAST_UPDATED_BY ,put.LAST_UPDATE_LOGIN ,put.CREATED_BY ,put.CREATION_DATE ,put.OBJECT_VERSION_NUMBER ,CASE WHEN ((put.business_group_id IS NULL AND put.legislation_code IS NULL) OR (put.business_group_id IS NULL AND put.legislation_code = NVL(hr_bis.get_legislation_code,put.legislation_code)) OR (put.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, put.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_user_tables put WITH READ ONLY

View Text - HTML Formatted

SELECT PUT.USER_TABLE_NAME
, HR_BIS.BIS_DECODE_LOOKUP('RANGE_MATCH'
, PUT.RANGE_OR_MATCH) RANGE_OR_MATCH
, HR_BIS.BIS_DECODE_LOOKUP('DATA_TYPE'
, PUT.USER_KEY_UNITS) USER_KEY_UNITS
, PUT.USER_ROW_TITLE
, PUT.LEGISLATION_CODE
, PUT.LEGISLATION_SUBGROUP
, PUT.RANGE_OR_MATCH RANGE_OR_MATCH_CODE
, PUT.USER_KEY_UNITS USER_KEY_UNITS_CODE
, PUT.USER_TABLE_ID
, PUT.BUSINESS_GROUP_ID
, PUT.LAST_UPDATE_DATE
, PUT.LAST_UPDATED_BY
, PUT.LAST_UPDATE_LOGIN
, PUT.CREATED_BY
, PUT.CREATION_DATE
, PUT.OBJECT_VERSION_NUMBER
, CASE WHEN ((PUT.BUSINESS_GROUP_ID IS NULL
AND PUT.LEGISLATION_CODE IS NULL) OR (PUT.BUSINESS_GROUP_ID IS NULL
AND PUT.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PUT.LEGISLATION_CODE)) OR (PUT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUT.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_USER_TABLES PUT WITH READ ONLY