Post Sql bind not fetching Payroll Period in custom task flow

Hi

I have made a custom taks flow to run calculate payroll. I am trying to default the values of most of the fields using Post Sql bind. But It is giving "Critical Alert" error when running that flow

Following queries I have used against each parameter in Post Sql Bind

Payroll: select payroll_id from PAY_ALL_PAYROLLS_F,

Payroll period: SELECT ptp.period_name FROM pay_time_periods ptp,pay_all_payrolls_f pp WHERE pp.payroll_id = ptp.payroll_id AND pp.payroll_id = :PAYROLL AND SYSDATE BETWEEN pp.effective_start_date AND pp.effective_end_date AND ptp.period_category = 'E' AND ptp.start_date <= SYSDATE AND ptp.end_date >= SYSDATEORDER BY ptp.start_date DESC