DBA Data[Home] [Help]

APPS.CTO_CONFIG_BOM_PK dependencies on FND_PROFILE_OPTION_VALUES

Line 5313: from fnd_profile_option_values val,fnd_profile_options op

5309: delimiter varchar2(10);
5310: profile_setting varchar2(30);
5311: CURSOR profile_check IS
5312: select nvl(substr(profile_option_value,1,30),'N')
5313: from fnd_profile_option_values val,fnd_profile_options op
5314: where op.application_id = 401
5315: and op.profile_option_name = 'USE_NAME_ICG_DESC'
5316: and val.level_id = 10001 /* This is for site level */
5317: and val.application_id = op.application_id