APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_SITE_V

Line 387: ** fnd_profile_values_site_v

383: ** get_site_value
384: ** get the profile option's site-level value based on the profile
385: ** option's id. The results are cached using the PL/SQL cross-session
386: ** function result caching mechanism. This has a dependency on the view
387: ** fnd_profile_values_site_v
388: */
389: FUNCTION get_site_value
390: (
391: profileOptionId IN NUMBER,

Line 400: FROM fnd_profile_values_site_v

396: applicationId);
397: BEGIN
398: SELECT profile_option_value
399: INTO siteLevelValue
400: FROM fnd_profile_values_site_v
401: WHERE profile_option_id = profileOptionId
402: AND application_id = applicationId
403: AND profile_option_value IS NOT NULL;
404: corelog_using_name(profileName, 'SITE LEVEL=' || siteLevelValue);