SELECT ASSIGNMENT_LINK_USAGE_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , ELEMENT_LINK_ID , ASSIGNMENT_ID FROM PAY_ASSIGNMENT_LINK_USAGES_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
View Text - HTML Formatted
SELECT ASSIGNMENT_LINK_USAGE_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , ELEMENT_LINK_ID , ASSIGNMENT_ID FROM PAY_ASSIGNMENT_LINK_USAGES_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE