APPS.PQH_SIT_ENGINE SQL Statements

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

Line: 9

   select attribute_id, value_style_cd
   into l_attribute_id, l_value_style_cd
   from pqh_txn_category_attributes
   where txn_category_attribute_id = p_txn_catg_attr_id;

Line: 35

   l_selected_value_v       varchar2(2000);

Line: 36

   l_selected_value_n       number;

Line: 37

   l_selected_value_d       date;

Line: 45

   select column_name, master_table_route_id,column_type
   into   l_column_name, l_table_route_id,l_column_type
   from   pqh_attributes
   where  attribute_id = p_attribute_id;

Line: 58

   select from_clause, where_clause
   into   l_from_clause, l_where_clause_in
   from   pqh_table_route where table_route_id = l_table_route_id;

Line: 77

   hr_utility.set_location('select clause 1is : '||substr(l_column_name,1,40),50);

Line: 79

   hr_utility.set_location('select clause 2is : '||substr(l_column_name,1,40),50);

Line: 81

   hr_utility.set_location('select clause 3is : '||substr(l_column_name,1,40),50);

Line: 83

    l_sel_stmt := 'select '||l_column_name||' from '||l_from_clause||' where '||l_where_clause_out ;

Line: 94

      execute immediate l_sel_stmt into l_selected_value_d;

Line: 96

      l_selected_value_v := fnd_date.date_to_canonical(l_selected_value_d);

Line: 99

      execute immediate l_sel_stmt into l_selected_value_n;

Line: 100

      l_selected_value_v := to_char(l_selected_value_n);

Line: 103

      execute immediate l_sel_stmt into l_selected_value_v;

Line: 105

   hr_utility.set_location('leaving with value: '||l_selected_value_v, 90);

Line: 106

   return l_selected_value_v;

Line: 239

        select * from pqh_fr_stat_situation_rules
        where statutory_situation_id = p_stat_sit_id
        and nvl(enabled_flag,'N') ='Y'
        and required_flag = p_required_flag
        order by processing_sequence;