SELECT APPLICATION_ID , PROFILE_OPTION_ID , PROFILE_OPTION_VALUE
FROM FND_PROFILE_OPTION_VALUES FPOV
WHERE LEVEL_ID = 10001
AND LEVEL_VALUE = 0
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
APPS.FND_PROFILE_VALUES_SITE_V
[Home] [Help]