EBS HRMS 定制化配置(5)

PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND PPS.DATE_START BETWEEN PAAF.EFFECTIVE_START_DATE AND PAAF.EFFECTIVE_END_DATE AND PPS.DATE_START BETWEEN PPU.EFFECTIVE_START_DATE AND PPU.EFFECTIVE_END_DATE

AND SUP.EFFECTIVE_START_DATE(+) <= PAAF.EFFECTIVE_START_DATE AND SUP.EFFECTIVE_END_DATE(+) > TRUNC(SYSDATE) AND PAPF.PERSON_ID = XHIPV.PERSON_ID

) resultTable -- ) WHERE Row_Num BETWEEN and