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 3153: from fnd_profile_options_vl

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