Query to get Payroll Task Name using LDG in Fusion HCM

 select prc.category_name
 from pay_report_categories_vl prc
 where (prc.legislative_data_group_id in (select ldg.legislative_data_group_id from per_legislative_data_groups_vl ldg
                                           where ldg.name = :LDGName
                                          )
 or nvl(prc.legislation_code, 'US') = 'US')
   and exists (select 1 from pay_payroll_actions ppa
                where prc.report_category_id = ppa.report_category_id
                    and ppa.action_type in (select lookup_code from hr_lookups where lookup_type = 'ACTION_TYPE' and meaning like nvl(:ProcessTypeName, '%')))
order by 1

ProcessTypeName :

select meaning from hr_lookups where lookup_type = 'ACTION_TYPE'

order by 1

LDGName:

select name from per_legislative_data_groups_vl

order by 1