Product: | HXC - Time and Labor Engine |
---|---|
Description: | Time Entry Rule Components |
Implementation/DBA Data: | APPS.HXC_TIME_ENTRY_RULE_COMPS_V |
SELECT EGC.ROWID ROW_ID
, EGC.ENTITY_GROUP_COMP_ID TIME_ENTRY_GROUP_COMP_ID
, EGC.ENTITY_GROUP_ID TIME_ENTRY_RULE_GROUP_ID
, EGC.ENTITY_ID TIME_ENTRY_RULE_ID
, TER.NAME TIME_ENTRY_RULE_NAME
, EGC.ATTRIBUTE1 RULE_OUTCOME
, LK.MEANING RULE_OUTCOME_NAME
, TER.RULE_USAGE
, TER.RULE_USAGE_NAME
, TER.MAPPING_ID
, TER.MAPPING_NAME
, TER.FORMULA_ID
, TER.FF_DESCRIPTION FORMULA_NAME
, TER.DESCRIPTION
, TER.START_DATE
, DECODE( TER.END_DATE
, HR_GENERAL.END_OF_TIME
, NULL
, TER.END_DATE) END_DATE
, EGC.ATTRIBUTE_CATEGORY
, EGC.ATTRIBUTE1
, EGC.ATTRIBUTE2
, EGC.ATTRIBUTE3
, EGC.ATTRIBUTE4
, EGC.ATTRIBUTE5
, EGC.ATTRIBUTE6
, EGC.ATTRIBUTE7
, EGC.ATTRIBUTE8
, EGC.ATTRIBUTE9
, EGC.ATTRIBUTE10
, EGC.ATTRIBUTE11
, EGC.ATTRIBUTE12
, EGC.ATTRIBUTE13
, EGC.ATTRIBUTE14
, EGC.ATTRIBUTE15
, EGC.ATTRIBUTE16
, EGC.ATTRIBUTE17
, EGC.ATTRIBUTE18
, EGC.ATTRIBUTE19
, EGC.ATTRIBUTE20
, EGC.ATTRIBUTE21
, EGC.ATTRIBUTE22
, EGC.ATTRIBUTE23
, EGC.ATTRIBUTE24
, EGC.ATTRIBUTE25
, EGC.ATTRIBUTE26
, EGC.ATTRIBUTE27
, EGC.ATTRIBUTE28
, EGC.ATTRIBUTE29
, EGC.ATTRIBUTE30
, EGC.OBJECT_VERSION_NUMBER
, EGC.CREATED_BY
, EGC.CREATION_DATE
, EGC.LAST_UPDATED_BY
, EGC.LAST_UPDATE_DATE
, EGC.LAST_UPDATE_LOGIN
FROM HR_LOOKUPS LK
, HXC_TIME_ENTRY_RULES_V TER
, HXC_ENTITY_GROUP_COMPS EGC
WHERE EGC.ENTITY_TYPE = 'TIME_ENTRY_RULES'
AND TER.TIME_ENTRY_RULE_ID = EGC.ENTITY_ID
AND LK.LOOKUP_TYPE = 'HXC_TIME_ENTRY_RULE_OUTCOME'
AND LK.LOOKUP_CODE = EGC.ATTRIBUTE1