[Home] [Help]
621: WHERE MANDATORY_FLAG = 'Y'
622: AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
623: AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
624: */
625: FROM PA_VALID_CATEGORIES_V VC,
626: PA_PROJECTS_ALL PPA,
627: PA_PROJECT_TYPES_ALL PPTA
628: WHERE VC.MANDATORY_FLAG = 'Y'
629: AND PPA.PROJECT_ID = x_project_id