Extraction not working with Custom Output Set

Hi, 

We basically want to choose the Solicitation Campaign and the related Goal Amt and display those columns when we run the extractions. I added 2 parameters to an existing template in Output Set builder. The columns show up when I use 'Execute and output set ' and choose the template with the custom parameters(Recent Campaign and Recent Goal ) but when I try to run an extraction it does not extract anything when I choose that output set. 

So,  I have 2 variable Recent Campaign and Recent Goal 

I added the following entries in TR_QUERY_ELEMENT

Recent Campaign

data Select : !.camp_desc1

Data From : 
 (select v.customer_no,goal_amt1 = v.goal_amt,campaign_no1 = v.campaign_no,camp_desc1 = c.description from vs_solicitation v JOIN  t_campaign c ON v.campaign_no = c.campaign_no)
Data Where : 
!.campaign_no1 =  <<p6>>
 
 

Recent Goal

data Select : !.goal_amt1

Data From : 
 (select v.customer_no,goal_amt1 = v.goal_amt,campaign_no1 = v.campaign_no,camp_desc1 = c.description from vs_solicitation v JOIN  t_campaign c ON v.campaign_no = c.campaign_no)
Data Where : 
!.campaign_no1 =  <<p6>>
 
In tr_query_elements_Parameter : 
I added Tbl : T_CAMPAIGN
ID :campaign_no
WHERE :campaign_no in (1346,1328,1387,1520,1193,1374,1375)
 
 
Could you please look at this and let me know whats missing ? 
 
Thank you,
Snehal