SELECT 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 ('NR' , 'L' , 'LM' , 'M' , 'MH' , 'H' , 'S') AND PAYEEID IS NULL ORDER BY SEQ