Need Payroll costing query to fetch the Element eligibility costing information

Summary

Payroll costing

Content

I need to update the costing segment values at Element eligibility level. I tried to load the new costing segment values usinf CostAllocationAccount.dat HDL file with an effective date of 01/04/2020 but it did a correction instead of update. Then I tried to create the ConstingInfo.dat abd CostingAllocation.dat file with an Effective start date of 01/04/2020 to update the costing segment value but here I stuck finding the element eligibility records of all costable types.

Could anyone share a query so that it should fetch the below mentioned column values from pay_cost_info_f, pay_cost_allocation_f and pay_cost_allocation_accounts tables.