Query for checking whether patch is applied or not

select * from jai_applied_patches where patch_number = 7530017
select * from ad_applied_patches where patch_name =