DBA Data[Home] [Help]

APPS.CTO_UPDATE_BOM_RTG_PK dependencies on FND_PROFILE_OPTION_VALUES

Line 6913: from fnd_profile_option_values val,fnd_profile_options op

6909: delimiter varchar2(10);
6910: profile_setting varchar2(30);
6911: CURSOR profile_check IS
6912: select nvl(substr(profile_option_value,1,30),'N')
6913: from fnd_profile_option_values val,fnd_profile_options op
6914: where op.application_id = 401
6915: and op.profile_option_name = 'USE_NAME_ICG_DESC'
6916: and val.level_id = 10001 /* This is for site level */
6917: and val.application_id = op.application_id