Product: | PAY - Payroll |
---|---|
Description: | Discoverer base view for pay_user_tables. |
Implementation/DBA Data: | APPS.PAYBV_USER_TABLE |
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