SELECT A.INSTITUTION , A.SSR_ACTIVITY_ID , B.DESCR50 FROM PS_SSR_ACTIVITY A , PS_SSR_AC_REG_HDR B WHERE A.SSR_AC_CONTENT_ID = B.SSR_AC_CONTENT_ID AND A.INSTITUTION = B.INSTITUTION AND %CurrentDateIn BETWEEN B.EFFDT AND B.END_EFFDT AND B.EFF_STATUS = 'A' AND EXISTS ( SELECT 'X' FROM PS_SSR_IAM WHERE INSTITUTION = A.INSTITUTION AND SSR_ACTIVITY_ID= A.SSR_ACTIVITY_ID AND SSR_IAM_ACT_STATUS = 'SR' ) AND EXISTS ( SELECT 'X' FROM ps_ssr_acmcont_itm WHERE ssr_activity_id = A.ssr_activity_id AND ssr_blind_graded = 'Y')
|