APPS.FII_EA_SOURCE_PKG SQL Statements

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

Line: 126

   SELECT
               FII_EA_COL_LEDGER_ID,
               FII_EA_COL_LEDGER,
               FII_EA_COL_JOURNAL_SOURCE,
               FII_EA_COL_JE_SOURCE_CODE,
               FII_EA_COL_FUNC_CURRENCY,
               FII_EA_FUNC_AMT,
               FII_EA_XTD,
               FII_EA_GT_XTD,
               decode(FII_EA_COL_JOURNAL_SOURCE,''AP Translator'','''||l_url_ap||''', ''Payables'','''||l_url_ap||''',
                ''Assets'','''||l_url_fa||''', '''||l_url_other||''') FII_EA_FUNC_AMT_DRILL
   FROM  (SELECT
               sob.id                   FII_EA_COL_LEDGER_ID,
               sob.value                FII_EA_COL_LEDGER,
               jes.user_je_source_name  FII_EA_COL_JOURNAL_SOURCE,
               f.je_source              FII_EA_COL_JE_SOURCE_CODE,
               f.functional_currency    FII_EA_COL_FUNC_CURRENCY,
               '||p_multi_factor||' * sum(f.amount_b)         FII_EA_FUNC_AMT,
               '||p_multi_factor||' * sum(f.amount_g)         FII_EA_XTD,
               '||p_multi_factor||' * sum(sum(f.amount_g)) over()  FII_EA_GT_XTD,
               (rank () OVER (ORDER BY NLSSORT(sob.value, ''NLS_SORT= BINARY'') ASC
                                       nulls last)) - 1  rnk
        from fii_gl_je_summary_b'||l_curr_view||'  f,
             fii_ledger_v sob,
             fii_time_structures cal,
             gl_je_sources_tl jes
        where cal.report_date = :ASOF_DATE
        and bitand(cal.record_type_id, :ACTUAL_BITAND) = :ACTUAL_BITAND
        and cal.time_id = f.time_id
        and cal.period_type_id = f.period_type_id
        and sob.id = f.ledger_id
        and f.company_id = &FII_COMPANIES+FII_COMPANIES
        and f.cost_center_id = &ORGANIZATION+HRI_CL_ORGCC
        and f.fin_category_id =  &FINANCIAL ITEM+GL_FII_FIN_ITEM
        AND     f.je_source = jes.je_source_name
        and     jes.language =   userenv(''LANG'')
        '||l_ledger_where||l_fud1_where||l_fud2_where||'
        group by sob.id,
                 sob.value,
                 jes.user_je_source_name,
                 f.je_source,
                 f.functional_currency)
        WHERE ((rnk between &START_INDEX and &END_INDEX) or (&END_INDEX = -1))
        ORDER BY NLSSORT(FII_EA_COL_LEDGER, ''NLS_SORT= BINARY'') ASC,NLSSORT(FII_EA_COL_JOURNAL_SOURCE,''NLS_SORT= BINARY'') ASC,  FII_EA_XTD DESC, NLSSORT(FII_EA_COL_FUNC_CURRENCY, ''NLS_SORT= BINARY'') ASC nulls last';