[Home] [Help]
View: PAY_ELEMENT_SETS_V
Product: | PAY - Payroll |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.PAY_ELEMENT_SETS_V
|
View Text
SELECT ELS.ROWID ROW_ID
, ELS.ELEMENT_SET_ID
, ELS.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, ELS.LEGISLATION_CODE
, ELS.ELEMENT_SET_NAME
, ELS.ELEMENT_SET_TYPE
, ELS.COMMENTS
, ELS.LAST_UPDATE_DATE
, ELS.LAST_UPDATED_BY
, ELS.LAST_UPDATE_LOGIN
, ELS.CREATED_BY
, ELS.CREATION_DATE
, HL.MEANING ELEMENT_SET_TYPE_MEANING
FROM PAY_ELEMENT_SETS ELS
, HR_LOOKUPS HL
WHERE HL.LOOKUP_TYPE = 'ELEMENT_SET_TYPE'
AND HL.LOOKUP_CODE = ELS.ELEMENT_SET_TYPE
Columns
Name |
ROW_ID |
ELEMENT_SET_ID |
BUSINESS_GROUP_ID |
LEGISLATION_CODE |
ELEMENT_SET_NAME |
ELEMENT_SET_TYPE |
COMMENTS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
ELEMENT_SET_TYPE_MEANING |