SELECT PTD.DISTRIBUTION_RULE , DR.MEANING , PTD.PROJECT_TYPE , PAP.PROJECT_ID FROM PA_PROJECT_TYPE_DISTRIBUTIONS PTD , PA_DISTRIBUTION_RULES DR , PA_PROJECTS PAP WHERE PTD.DISTRIBUTION_RULE = DR.DISTRIBUTION_RULE AND PTD.PROJECT_TYPE = PAP.PROJECT_TYPE AND PAP.TEMPLATE_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN DR.START_DATE_ACTIVE AND NVL(DR.END_DATE_ACTIVE , TRUNC(SYSDATE))