PARAM_EFFECTIVE_DATE based on payroll balance effective date

Hi Team,

We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective date. But, currently it is fetching based on sysdate. How to pass the param effective date based on balance effective date?

Thanks.