APPS.BEN_PROFILE_HANDLER SQL Statements

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

Line: 57

    select 1
    from all_tab_columns
    where table_name = p_table
    and column_name = p_column
    and owner = upper(p_oracle_schema);

Line: 116

  if l_event not in ('CREATE','DELETE','UPGRADE') then
    --
    fnd_message.set_name('BEN','BEN_92466_EVENT_HANDLER');

Line: 180

  l_dynamic_sql := 'select count(*)
                    from   '||p_reference_table||' '||
                   'where  '||p_reference_table_column||' = :1';

Line: 191

    l_dynamic_sql := 'update '||p_base_table||' '||
                     'set    '||p_base_table_reference_column||' = :1
                      where  '||p_base_table_column||' = :2';

Line: 197

  elsif l_event = 'DELETE' and
    l_rows = 0 then
    --
    l_dynamic_sql := 'update '||p_base_table||' '||
                     'set    '||p_base_table_reference_column||' = :1
                      where  '||p_base_table_column||' = :2';

Line: 209

    l_dynamic_sql := 'update '||p_base_table||' '||
                     'set    '||p_base_table_reference_column||' = :1
                      where  '||p_base_table_column||' = :2';

Line: 218

    l_dynamic_sql := 'update '||p_base_table||' '||
                     'set    '||p_base_table_reference_column||' = :1
                      where  '||p_base_table_column||' = :2';