I have Dynamic Sender Profile' functionality enabled within our business unit. I have created a sender profile encompassing verified "%%FromName%%" and %%FromEmailAddress%% which is connected with send a classification.

The below ampscript is embedded in the email which is not providing the desired output in the From email address and From name areas of the email. 

%%[ 
VAR @FromEmailAddress
SET @FromEmailAddress = Lookup("DE TABLE","FROM_Email_ADDRESS","Email_Address", emailaddr) 
IF EMPTY (@FromEmailAddress) THEN 
    SET @FromEmailAddress = '[email protected]' 
ENDIF 

VAR @FromName
SET @FromName = Lookup("DE TABLE","Full_Name","Email_Address", emailaddr) 
IF EMPTY (@FromName) THEN 
    SET @FromName = 'CEO' 
ENDIF 
]%%  
Note: The lookup table is not the target DE.
Am I missing a step here on the ampscript call out? Thanks