DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_APPL_V

Line 417: ** dependency on the view fnd_profile_values_appl_v

413: ** get_appl_value
414: ** get the profile option's application-level value based on the profile
415: ** option's id and level_value. The results are cached using the PL/SQL
416: ** cross-session function result caching mechanism. This has a
417: ** dependency on the view fnd_profile_values_appl_v
418: */
419: FUNCTION get_appl_value
420: (
421: profileOptionId IN NUMBER,

Line 431: FROM fnd_profile_values_appl_v

427: applicationId);
428: BEGIN
429: SELECT profile_option_value
430: INTO applLevelValue
431: FROM fnd_profile_values_appl_v
432: WHERE profile_option_id = profileOptionId
433: AND application_id = applicationId
434: AND level_value = applId
435: AND profile_option_value IS NOT NULL;