DBA Data[Home] [Help]

APPS.OKS_PROFILES_VISIBLE dependencies on FND_PROFILE_OPTIONS_VL

Line 15: from fnd_profile_options_vl fpovl,

11: select replace(substr(upper(fpovl.sql_validation),instr(upper(fpovl.sql_validation),'SELECT',1,1)-1,
12: instr(upper(fpovl.sql_validation),'COLUMN',1,1) -
13: instr(upper(fpovl.sql_validation),'SELECT',1,1)),'\','') SQL_VALID,
14: fpov.profile_option_value PROF_VAL
15: from fnd_profile_options_vl fpovl,
16: fnd_profile_option_values fpov
17: where fpovl.profile_option_id = p_profile_option_id
18: and fpov.profile_option_id = fpovl.profile_option_id
19: and fpov.level_id = p_level_id