[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 |
APPS.HXT_HOUR_DEDUCTION_RULES_FMV