DBA Data[Home] [Help]

APPS.BOMPLDCB dependencies on FND_PROFILE_OPTION_VALUES

Line 22: from fnd_profile_option_values val,fnd_profile_options op

18: delimiter varchar2(10);
19: profile_setting varchar2(30);
20: CURSOR profile_check IS
21: select nvl(substr(profile_option_value,1,30),'N')
22: from fnd_profile_option_values val,fnd_profile_options op
23: where op.application_id = 401
24: and op.profile_option_name = 'USE_NAME_ICG_DESC'
25: and val.level_id = 10001 /* This is for site level */
26: and val.application_id = op.application_id