APPS.BSC_OPTION_WRAPPER SQL Statements

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

Line: 4

procedure Update_Option_Name(
  p_old_option_name			varchar2
 ,p_new_option_name			varchar2
 ,p_option_dim_levels		varchar2
 ,p_option_description		varchar2
) is

TYPE Recdc_value		IS REF CURSOR;

Line: 37

  l_sql := 'select distinct indicator ' ||
           '               ,analysis_group_id ' ||
           '               ,option_id ' ||
           '  from BSC_OPTS_PMF_MEAS_V ' ||
           ' where option_name = :1'||
           ' and dim_levels = :2';

Line: 50

      BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options( l_commit
                                                      ,l_Anal_Opt_Rec
                                                      ,l_return_status
                                                      ,l_msg_count
                                                      ,l_msg_data);

Line: 81

end Update_Option_Name;