[Home] [Help]
View: HXT_EARNING_RULES_FMV
View Text
SELECT HER.ROWID ROW_ID
, HER.ID
, HER.ELEMENT_TYPE_ID
, HER.EGP_ID
, HER.SEQ_NO
, HER.NAME
, HER.EGR_TYPE
, HRL.MEANING
, HER.HOURS
, HER.EFFECTIVE_START_DATE
, HER.DAYS
, HER.EFFECTIVE_END_DATE
, HER.CREATED_BY
, HER.CREATION_DATE
, HER.LAST_UPDATED_BY
, HER.LAST_UPDATE_DATE
, HER.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS HRL
, HXT_EARNING_RULES HER
WHERE HRL.LOOKUP_TYPE(+) = 'HXT_EARN_RULE_TYPE'
AND HRL.LOOKUP_CODE(+) = HER.EGR_TYPE
AND HRL.APPLICATION_ID(+) = 808
Columns
Name |
ROW_ID |
ID |
ELEMENT_TYPE_ID |
EGP_ID |
SEQ_NO |
NAME |
EGR_TYPE |
MEANING |
HOURS |
EFFECTIVE_START_DATE |
DAYS |
EFFECTIVE_END_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |