Resource Calendar

Below is the query to get calendar of a resource

select srmr.unique_name,
srmr.full_name,
prc1.prname basecalendar,
prc.prname calendar
from srm_resources srmr,
prj_resources prjr,
prcalendar prc,
prcalendar prc1
where srmr.is_Active=1
and srmr.person_type<>0
and srmr.id=prjr.prid
and prjr.prcalendarid=prc.prid
and prc.prbasecalendarid=prc1.prid(+)