Product: | HXC - Time and Labor Engine |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXC_RESOURCE_ELIG_PREF_V |
SELECT RESOURCE_ID
, RULE_EVALUATION_ORDER
, RULE_NAME
, BUSINESS_GROUP_ID
, LEGISLATION_CODE
, PREFERENCE_ID
, PREFERENCE_CODE
, PREFERENCE_NAME
, EDIT_ALLOWED
, DISPLAYED
, HIERARCHY_NAME
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM HXC_RESOURCE_ALL_ELIG_PREF_V V1
WHERE V1.RULE_EVALUATION_ORDER = (SELECT MAX(V2.RULE_EVALUATION_ORDER)
FROM HXC_RESOURCE_ALL_ELIG_PREF_V V2
WHERE V1.RESOURCE_ID = V2.RESOURCE_ID
AND V1.PREFERENCE_CODE = V2.PREFERENCE_CODE)