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