DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_SERVER_V

Line 530: ** dependency on the view fnd_profile_values_server_v

526: ** get_server_value
527: ** get the profile option's server-level value based on the profile
528: ** option's id and level_value. The results are cached using the PL/SQL
529: ** cross-session function result caching mechanism. This has a
530: ** dependency on the view fnd_profile_values_server_v
531: **
532: ** This is called in get_specific_value().
533: */
534: FUNCTION get_server_value

Line 546: FROM fnd_profile_values_server_v

542: applicationId);
543: BEGIN
544: SELECT profile_option_value
545: INTO serverLevelValue
546: FROM fnd_profile_values_server_v
547: WHERE profile_option_id = profileOptionId
548: AND application_id = applicationId
549: AND level_value = serverId
550: AND profile_option_value IS NOT NULL;