APPS.BIX_PMV_AI_SLTR_PRTLT_PKG SQL Statements

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

Line: 19

l_view_by_select             VARCHAR2(32000);

Line: 70

                     ,p_view_by_select  => l_view_by_select
                     ,p_view_by         => l_dummy);

Line: 102

   l_sqltext := 'SELECT name VIEWBY,
                        SUM(p_ansgoal)*100/DECODE(SUM(p_offrd),0,null,SUM(p_offrd))           BIX_PMV_AI_PREVSL,
                        SUM(curr_ansgoal)*100/DECODE(SUM(curr_offrd),0,null,SUM(curr_offrd))  BIX_PMV_AI_SL,
                        ' || l_goal ||'                           BIX_PMV_AI_SLGOAL
                 FROM '||'(SELECT iset.*,cal.start_date st_date,cal.name
                           FROM '||
                           bix_pmv_dbi_utl_pkg.trend_sql
                                   (p_xtd             => l_xtd,
                                    p_comparison_type => l_comp_type,
                                    p_fact_name       => l_mv,
                                    p_where_clause    => l_where_clause,
                                    p_col_name        => bix_col_tab,
                                    p_use_grpid       => 'N',
                                    p_in_join_tables  => NULL,
                                    p_fact_hint       => NULL,
                                    p_union_clause    =>l_union_all_text )||'
                           ) GROUP BY  name ,st_date order by st_date ';