After upgrade to 12.1 sql query not working for report

After upgrading from Tessitura 11 to 12.1 one of our reports is not functioning. I have narrowed it down to a sql table that is returning a null value, for T_PMAP.gl_hold_no but can view  the table and have verify that values do exist. Does anyone have an idea what might be wrong with the sql statement below?

SELECT T_PERF.perf_code,
T_PERF.perf_dt,

T_PMAP.gl_hold_no,
T_TRANSACTION.trn_amt,
T_BATCH.post_no

FROM T_TRANSACTION

LEFT OUTER JOIN T_FEE ON T_TRANSACTION.fee_no = T_FEE.fee_no
LEFT OUTER JOIN T_FUND ON T_TRANSACTION.fund_no = T_FUND.fund_no
LEFT OUTER JOIN T_PMAP ON T_TRANSACTION.pmap_no = T_PMAP.pmap_no

JOIN T_CAMPAIGN ON T_TRANSACTION.campaign_no = T_CAMPAIGN.campaign_no
LEFT OUTER JOIN T_BATCH ON T_TRANSACTION.batch_no = T_BATCH.batch_no
LEFT OUTER JOIN TR_BATCH_TYPE ON T_BATCH.batch_type = TR_BATCH_TYPE.id
LEFT OUTER JOIN T_PERF ON T_TRANSACTION.perf_no = T_PERF.perf_no

WHERE T_TRANSACTION.perf_no>0 AND T_BATCH.post_no = 2382