DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_SERVRESP_V

Line 604: ** This has a dependency on the view fnd_profile_values_servresp_v

600: ** get_servresp_level_value
601: ** get the profile option's servresp level value based on the profile
602: ** option's id, responsibility and server context. The results are cached
603: ** using the PL/SQL cross-session function result caching mechanism.
604: ** This has a dependency on the view fnd_profile_values_servresp_v
605: **
606: ** This is called in get_specific_value().
607: */
608: FUNCTION get_servresp_value

Line 622: FROM fnd_profile_values_servresp_v

618: applicationId);
619: BEGIN
620: SELECT profile_option_value
621: INTO servrespLevelValue
622: FROM fnd_profile_values_servresp_v
623: WHERE profile_option_id = profileOptionId
624: AND application_id = applicationId
625: AND level_value = respId
626: AND level_value_application_id = applId