Get the list of persons included in an Access for a Learning Offering

Summary

Access Group Details For each Offering name and Employee

Content

Hi  Every One,

for an Offering in the Learning Catalog I have created an Access Group. I would like to extract from HCM tables the list of persons and Offering name  that are included in that Access. Now, i am getting Access group details but i need to show Offering name is also in BIP report . 

Which table and table field  i need to join to get the Offering Name  . Please help me on below query

SQL:

SELECT mail.person_number, wlit.name

  FROM wlf_learning_items_f wlif