Query does not show any data.

HI

When trying to execute the below query with parameters nothing shows up .where as when we run the report from application data shows up. "Cleared Transaction Report".

Queried the View  "CE_801_RECONCILED_V" individually but no data shows up even after setting the ENV .

Please suggest.

SELECT ba.bank_account_name bank_account_name,

  ba.bank_account_num bank_account_num,

  BankParty.PARTY_NAME bank_name,

  BranchParty.PARTY_NAME bank_branch_name,

  'PAYROLL' type,

  'PAYROLL' break_type,

  'Payroll' type_dsp,

  c.vendor_name supplier_customer,

  c.trx_date trx_date,

  c.maturity_date maturity_date,

  c.amount bank_account_amount,