Product: | PAY - Payroll |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PAY_USER_TABLES_V |
SELECT PUT.ROWID ROW_ID
, PUT.USER_TABLE_ID
, PUT.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PUT.LEGISLATION_CODE
, PUT.RANGE_OR_MATCH
, LO.MEANING
, PUT.USER_KEY_UNITS
, FF.MEANING UNITS_MEANING
, PUT.USER_TABLE_NAME
, PUT.USER_ROW_TITLE
, PUT.LEGISLATION_SUBGROUP
, PUT.LAST_UPDATE_DATE
, PUT.LAST_UPDATED_BY
, PUT.LAST_UPDATE_LOGIN
, PUT.CREATED_BY
, PUT.CREATION_DATE
FROM HR_LOOKUPS FF
, HR_LOOKUPS LO
, PAY_USER_TABLES PUT
WHERE LO.LOOKUP_TYPE = 'RANGE_MATCH'
AND LO.LOOKUP_CODE = PUT.RANGE_OR_MATCH
AND FF.LOOKUP_TYPE = 'DATA_TYPE'
AND FF.LOOKUP_CODE = PUT.USER_KEY_UNITS