[Home] [Help]
View: PAYBV_RUN_RESULT
View Text
SELECT HR_BIS.BIS_DECODE_LOOKUP('ENTRY_TYPE'
, PRR.ENTRY_TYPE) ENTRY_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('RUN_RESULT_SOURCE_TYPE'
, PRR.SOURCE_TYPE) SOURCE_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('RUN_RESULT_STATUS'
, PRR.STATUS) STATUS
, PRR.JURISDICTION_CODE
, PRR.START_DATE
, PRR.END_DATE
, PRR.ENTRY_TYPE ENTRY_TYPE_CODE
, PRR.SOURCE_TYPE SOURCE_TYPE_CODE
, PRR.STATUS STATUS_CODE
, PRR.RUN_RESULT_ID
, PRR.ELEMENT_TYPE_ID
, PRR.ASSIGNMENT_ACTION_ID
, PRR.SOURCE_ID
FROM PAY_RUN_RESULTS PRR WITH READ ONLY
Columns
Name |
ENTRY_TYPE |
SOURCE_TYPE |
STATUS |
JURISDICTION_CODE |
START_DATE |
END_DATE |
ENTRY_TYPE_CODE |
SOURCE_TYPE_CODE |
STATUS_CODE |
RUN_RESULT_ID |
ELEMENT_TYPE_ID |
ASSIGNMENT_ACTION_ID |
SOURCE_ID |