Custom POSPAY troubles for PAYEE
We have a custom POSPAY process to pull for physical third party checks and employee payroll checks. in switching banks in the last few months we have had to add the payee name to these otherwise the bank will reject the POSPAY file. This all seems to go well for the physical payroll checks that get processed, however I need to do a query to pull the appropriate payee name rather than the employee name. I am able to find the payee name needed in hr_all_organization_units.name. however, I'm not certain how I can join this to the proper pay_* or