APPS.BIS_COMMON_PARAMETERS dependencies on FND_PROFILE_OPTIONS

Line 10: from fnd_profile_options

6:
7: FUNCTION get_value_at_site_level(pname IN VARCHAR2) RETURN VARCHAR2 IS
8: CURSOR c_profile_info(pname VARCHAR2) IS
9: select profile_option_id, application_id
10: from fnd_profile_options
11: where profile_option_name = upper(pname)
12: and start_date_active <= sysdate
13: and nvl(end_date_active, sysdate) >= sysdate;
14:

Line 379: l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';

375: return '';
376: end if;
377:
378: --get sqlvalidation
379: l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';
380: execute immediate l_temp into sqlvalidation using name;
381:
382: --if there is no sql validation, display value is same as internal value.
383: if (sqlvalidation is null) then