DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_PROFILE_VALUES_RESP_V

Line 454: ** fnd_profile_values_resp_v

450: ** get the profile option's responsibility-level value based on the
451: ** profile option's id, level_value, and level_value_application_id. The
452: ** results are cached using the PL/SQL cross-session function result
453: ** caching mechanism. This has a dependency on the view
454: ** fnd_profile_values_resp_v
455: */
456: FUNCTION get_resp_value
457: (
458: profileOptionId IN NUMBER,

Line 469: FROM fnd_profile_values_resp_v

465: applicationId);
466: BEGIN
467: SELECT profile_option_value
468: INTO respLevelValue
469: FROM fnd_profile_values_resp_v
470: WHERE profile_option_id = profileOptionId
471: AND application_id = applicationId
472: AND level_value = respId
473: AND level_value_application_id = applId