APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_USER_V

Line 493: ** dependency on the view fnd_profile_values_user_v

489: ** get_user_value
490: ** get the profile option's user-level value based on the profile
491: ** option's id and level_value. The results are cached using the PL/SQL
492: ** cross-session function result caching mechanism. This has a
493: ** dependency on the view fnd_profile_values_user_v
494: **
495: ** This is called in get_specific_value().
496: */
497: FUNCTION get_user_value

Line 509: FROM fnd_profile_values_user_v

505: applicationId);
506: BEGIN
507: SELECT profile_option_value
508: INTO userLevelValue
509: FROM fnd_profile_values_user_v
510: WHERE profile_option_id = profileOptionId
511: AND application_id = applicationId
512: AND level_value = userId
513: AND profile_option_value IS NOT NULL;