HR_LOOKUPS vs HCM_LOOKUPS View

Summary

Need to know the difference between HR Lookup and HCM Lookup view

Content

Can anyone let me know the difference between HR Lookup and HCM Lookup view.

From view SQL Statement i could see that HR Lookup has below decode statement which is not present in HCM Lookup.

AND decode(B.TAG, NULL, 'Y', decode(substr(B.TAG,1,1), '+', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'Y', 'N'), '-', decode(sign(instr(B.TAG, HR_API.GET_LEGISLATION_CONTEXT)), 1, 'N', 'Y'), 'Y' ) ) = 'Y'

Thanks,

Parthiban