SELECT BENEFICIARY_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , ELEMENT_ENTRY_ID , BENEFIT_LEVEL , PROPORTION , SOURCE_ID , SOURCE_TYPE , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE FROM BEN_BENEFICIARIES_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
SELECT BENEFICIARY_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ELEMENT_ENTRY_ID
, BENEFIT_LEVEL
, PROPORTION
, SOURCE_ID
, SOURCE_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM BEN_BENEFICIARIES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
|
|
|