Concurrent Program,Responsibility name and Requestor fetching details query

SELECT * FROM PER_ALL_PEOPLE_F

WHERE FULL_NAME LIKE '%SAN%'

SELECT * FROM FND_USER

WHERE EMPLOYEE_ID = 487

  SELECT REQUEST_ID,
         PHASE_CODE,
         STATUS_CODE,
         REQUEST_DATE,
         REQUESTED_BY,
         REQUESTOR,
         COMPLETION_TEXT,
         ARGUMENT_TEXT,
         PROGRAM,
         USER_CONCURRENT_PROGRAM_NAME,
         RESPONSIBILITY_NAME
    FROM FND_CONC_REQ_SUMMARY_V A, FND_RESPONSIBILITY_TL B
   WHERE     A.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
         AND A.USER_CONCURRENT_PROGRAM_NAME LIKE '%PDI%'
         AND REQUESTOR LIKE 'XX 1030%'
ORDER BY REQUEST_DATE DESC