SELECT LOOKUP_CODE,MEANING,DESCRIPTION
FROM fnd_lookups fndlup
where fndlup.lookup_type = 'OKC_TERMINATION_REASON'
and trunc(nvl(END_DATE_ACTIVE,sysdate)) >= trunc(sysdate)
FROM fnd_lookups fndlup
where fndlup.lookup_type = 'OKC_TERMINATION_REASON'
and trunc(nvl(END_DATE_ACTIVE,sysdate)) >= trunc(sysdate)
No comments:
Post a Comment