SELECT a.name,
       c.encryp_item_val,
       pkg_pci_cmmn_decrypt.fcn_get_decrypt_val_aes('BAT',
                                                    e.reference_nbr,
                                                    e.order_date,
                                                    'RA') as card_nbr,
       e.*
  FROM express_pay_order e, transaction_encryp_item c, agent a
 WHERE e.reference_nbr = c.tran_ref_id
   and e.rcv_agent_id = a.agent_id