[Home] [Help]
277: SELECT
278: COUNT(PERSON_ID)
279: INTO L_COUNT
280: FROM
281: PER_ALL_PEOPLE_F PPF
282: WHERE TRUNC(SYSDATE) between PPF.EFFECTIVE_START_DATE
283: AND PPF.EFFECTIVE_END_DATE
284: AND DECODE(PPF.MIDDLE_NAMES
285: ,NULL