DBA Data[Home] [Help]

APPS.OKS_SETUPRPT_PVT dependencies on FND_PROFILE_OPTIONS_VL

Line 21: from fnd_profile_options_vl fpovl,

17: (length(replace(substr(upper(fpovl.sql_validation),instr(upper(fpovl.sql_validation),'SELECT',1,1)-1,
18: instr(upper(fpovl.sql_validation),'COLUMN',1,1) -
19: instr(upper(fpovl.sql_validation),'SELECT',1,1)),'\','')) -2 ))SQL_VALID,
20: fpov.profile_option_value PROF_VAL
21: from fnd_profile_options_vl fpovl,
22: fnd_profile_option_values fpov
23: where fpovl.profile_option_id IN (
24: select profile_option_id
25: from fnd_profile_options_vl

Line 25: from fnd_profile_options_vl

21: from fnd_profile_options_vl fpovl,
22: fnd_profile_option_values fpov
23: where fpovl.profile_option_id IN (
24: select profile_option_id
25: from fnd_profile_options_vl
26: where application_id = 515)
27: and fpov.profile_option_id = fpovl.profile_option_id
28: and fpovl.USER_VISIBLE_FLAG = 'Y'
29: and fpov.profile_option_id = p_profile_option_id