[Home] [Help]
View: PQH_ROLES_V
Product: | PQH - Public Sector HR |
Description: | |
Implementation/DBA Data: |
APPS.PQH_ROLES_V
|
View Text
SELECT A.ROLE_ID
, A.BUSINESS_GROUP_ID
, A.ROLE_NAME
, HR_GENERAL.DECODE_LOOKUP('PQH_ROLE_TYPE'
, A.ROLE_TYPE_CD) ROLE_TYPE
, A.ROLE_TYPE_CD
, A.ENABLE_FLAG
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
, A.OBJECT_VERSION_NUMBER
FROM PQH_ROLES A
Columns
Name |
ROLE_ID |
BUSINESS_GROUP_ID |
ROLE_NAME |
ROLE_TYPE |
ROLE_TYPE_CD |
ENABLE_FLAG |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |
OBJECT_VERSION_NUMBER |