if u can't find what you are looking for in lookup table, how do you handle?
This Depend on the situation, To Check the value is there or not there two ways 1. Use notfound function (if possible) 2. Check the Key value from lkp as NULL Than based on the requirement generate error/Put default value