DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_PROFILE_OPTIONS_VL

Line 949: from fnd_profile_options_vl

945: select user_profile_option_name,
946: nvl(start_date_active,sysdate-1),
947: nvl(end_date_active,sysdate+1)
948: into l_user_prof_name, l_start_date, l_end_date
949: from fnd_profile_options_vl
950: where profile_option_name = p_prof_name;
951: exception
952: when no_data_found then
953: l_prof_value := 'DOESNOTEXIST';

Line 3157: from fnd_profile_options_vl

3153: select user_profile_option_name,
3154: nvl(start_date_active,sysdate-1),
3155: nvl(end_date_active,sysdate+1)
3156: into l_user_prof_name, l_start_date, l_end_date
3157: from fnd_profile_options_vl
3158: where profile_option_name = p_prof_name;
3159: exception
3160: when no_data_found then
3161: l_prof_value := 'DOESNOTEXIST';