HR_GENERAL.DECODE_LOOKUP not returning value
Summary:
HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed.
Content (required):
HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed.
Version (include the version you are using, if applicable):
21D
Code Snippet (add any code snippets that support your topic, if applicable):
Query:
select HR_GENERAL.DECODE_LOOKUP('PER_VISA_PERMIT_TYPE',PVPF.VISA_PERMIT_TYPE)
from PER_VISAS_PERMITS_F PVPF;
Here "PER_VISA_PERMIT_TYPE" is a user level lookup
Tagged:
0