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