HR_LOOKUPS vs HCM_LOOKUPS View
Summary
Need to know the difference between HR Lookup and HCM Lookup viewContent
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
0