[Home] [Help]
View: HXT_HOUR_DEDUCTION_RULES_FMV
View Text
SELECT HDR.ROWID ROW_ID
, HDR.HDP_ID
, HDR.FCL_DEDUCTION_TYPE
, HRL.MEANING
, HDR.EFFECTIVE_START_DATE
, HDR.HOURS
, HDR.TIME_PERIOD
, HDR.EFFECTIVE_END_DATE
, HDR.CREATED_BY
, HDR.CREATION_DATE
, HDR.LAST_UPDATED_BY
, HDR.LAST_UPDATE_DATE
, HDR.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS HRL
, HXT_HOUR_DEDUCTION_RULES HDR
WHERE HRL.LOOKUP_TYPE(+) = 'HXT_HOUR_DEDUCTION_TYPE'
AND HRL.LOOKUP_CODE(+) = HDR.FCL_DEDUCTION_TYPE
AND HRL.APPLICATION_ID(+) = 808
Columns
Name |
ROW_ID |
HDP_ID |
FCL_DEDUCTION_TYPE |
MEANING |
EFFECTIVE_START_DATE |
HOURS |
TIME_PERIOD |
EFFECTIVE_END_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |