Joining the PPR name to the positive pay scheduled job

Summary: I'm trying to find failed positive pay jobs and pull their associated PPR names. I have the pos pay sql and found some tables with the PPR name (IBY_SYS_PMT_PROFILES_B, IBY_PAYMENTS_ALL) But I can't figure out how they would connect.

Content (please ensure you mask any confidential information): Payment SQL

Version (include the version you are using, if applicable): 24C

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT
r.REQUESTID,
r.EXECUTABLE_STATUS, ---Succeeded
---r.USERNAME,
PPNF.FIRST_NAME,
PPNF.LAST_NAME,
r.PRODUCT,
to_char(cast(r.PROCESSSTART as timestamp) at time zone 'US/Pacific','MM-DD-YYYY HH:MI AM') as Process_Start,