The following query is applicable when your program name and plan are same. (I.e. you?re each program having separate plan and name of the both should be same)
SELECT * FROM SYSIBM.SYSPLANDEP
WHERE DNAME = 'program name' and BTYPE = 'T'
Actually, having separate plan for each program is not a usual practice and not a good practice. Most of the application program is bind with package after that it bound with plan. So we can very well go with the SYSIBM.SYSPACKDEP table for the getting the info about relation between the program and table.
The following query will give the details which you wanted
SELECT BNAME TABLE_NAME , BQUALIFIER QUALIFIER,
FROM SYSIBM.SYSPACKDEP WHERE BTYPE = 'T' AND BQUALIFIER='qualifier' AND DNAME=?programname?;