SELECT DISTINCT LOOKUP_CODE SCORE_TYPE , MEANING , SEQ FROM FND_LOOKUP_VALUES A , IBY_MAPPINGS B WHERE ENABLED_FLAG = 'Y' AND LOOKUP_TYPE = 'IBY_RISK_SCORE_TYPE' AND MAPPING_CODE = LOOKUP_CODE AND MAPPING_TYPE = LOOKUP_TYPE AND LANGUAGE = USERENV('LANG') AND LOOKUP_CODE IN ('L' , 'LM' , 'M' , 'MH' , 'H') AND PAYEEID IS NULL ORDER BY SEQ