SELECT APPLICATION_ID , PROFILE_OPTION_ID , PROFILE_OPTION_VALUE , LEVEL_VALUE , LEVEL_VALUE_APPLICATION_ID , LEVEL_VALUE2
FROM FND_PROFILE_OPTION_VALUES FPOV
WHERE LEVEL_ID = 10007
AND EXISTS
(SELECT 1
FROM FND_PROFILE_OPTIONS PO
WHERE PO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID
AND PO.APPLICATION_ID = FPOV.APPLICATION_ID
AND PO.START_DATE_ACTIVE <= ( TRUNC(SYSDATE + 1) - .000011574 )
AND (PO.END_DATE_ACTIVE IS NULL OR
PO.END_DATE_ACTIVE > ( TRUNC(SYSDATE) - .000011574 ))
)
ORDER BY PROFILE_OPTION_ID , APPLICATION_ID