APPS.OKS_PROFILES_VISIBLE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

select  replace(substr(upper(fpovl.sql_validation),instr(upper(fpovl.sql_validation),'SELECT',1,1)-1,
              instr(upper(fpovl.sql_validation),'COLUMN',1,1) -
              instr(upper(fpovl.sql_validation),'SELECT',1,1)),'\','') SQL_VALID,
        fpov.profile_option_value PROF_VAL
from 	fnd_profile_options_vl fpovl,
	    fnd_profile_option_values fpov
where	fpovl.profile_option_id = p_profile_option_id
and     fpov.profile_option_id = fpovl.profile_option_id
and	    fpov.level_id = p_level_id
and     fpov.application_id = p_application_id
and     fpov.level_value   = p_level_value
and     nvl(fpov.level_value_application_id,-99) = nvl(nvl(p_lvl_val_appl_id,fpov.level_value_application_id),-99)
--and     fpovl.application_id = 515
order by fpovl.profile_option_id,fpov.level_id,fpov.level_value;

Line: 50

    select instr(v_sql_valid,'INTO') into v_into_loc from dual;

Line: 51

    select instr(v_sql_valid,':VISIBLE_OPTION_VALUE') into v_visoval_loc from dual;

Line: 52

    select instr(v_sql_valid,':PROFILE_OPTION_VALUE') into v_profoval_loc from dual;

Line: 53

    select instr(v_sql_valid,'WHERE',-1,1) into v_whr_loc from dual;

Line: 54

    select instr(v_sql_valid,'FROM',1,1) into v_from_loc from dual;