[Home] [Help]
107: SELECT
108: FULL_NAME
109: INTO MEMBER_NAME
110: FROM
111: PER_PEOPLE_F
112: WHERE PERSON_ID = PROJECT_MEMBER
113: AND sysdate between EFFECTIVE_START_DATE
114: AND NVL(EFFECTIVE_END_DATE
115: ,SYSDATE + 1)