BI query to find the Personal Contribution(Yearly Cash In Lieu) request status and it's payout date

Summary:

BI query to find the Personal Contribution(Yearly Cash In Lieu) request status and it's payout date

Content (please ensure you mask any confidential information):

Hi Team,
I need BI query to find the Personal Contribution(Yearly Cash In Lieu) request status and If it is approved then In which payroll month it has been paid.
Need query between HRC_TXN_HEADER table and Payroll tables to track when employee paid for the approved request.
Below Payroll related tables.
pay_payroll_assignments ppas, pay_payroll_rel_actions ppra,pay_payroll_actions ppa, pay_requests pr, pay_flow_instances fi, pay_run_results prr, pay_run_result_values prrv, pay_time_periods ptp1, pay_rel_groups_dn paygroup, pay_assigned_payrolls_dn pap, pay_all_payrolls_f pay, pay_input_values_vl piv, pay_element_types_vl ele_type, pay_ele_classifications_vl ele_class