Make sure that address record is active (Sts = 'A') and that it is associated with the Name_ID that is selected in the Appeal table. For instance, if the address is associated with Name_ID 1 and the Appeal table has Name_ID 0, then it will not use the address with the SD specific use field value.