SELECT ELEMENT_ENTRY_VALUE_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , INPUT_VALUE_ID , ELEMENT_ENTRY_ID , SCREEN_ENTRY_VALUE FROM PAY_ELEMENT_ENTRY_VALUES_F WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
SELECT ELEMENT_ENTRY_VALUE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, INPUT_VALUE_ID
, ELEMENT_ENTRY_ID
, SCREEN_ENTRY_VALUE
FROM PAY_ELEMENT_ENTRY_VALUES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
|
|
|