APPS.JA_CN_PS_BI_EXPORT_PKG SQL Statements

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

Line: 111

  lv_sql_text := 'SELECT SUM(NVL(Jel.Accounted_Cr,0) - NVL(Jel.Accounted_Dr,0))';

Line: 147

  lv_sql_text := lv_sql_text || '               (SELECT MIN(Gp1.Start_Date)';

Line: 157

  lv_sql_text := lv_sql_text || '           AND (SELECT MAX(Gp2.End_Date)';

Line: 270

  lv_sql_text := 'SELECT SUM(NVL(Jel.Accounted_Cr,0) - NVL(Jel.Accounted_Dr,0))';

Line: 300

  lv_sql_text := lv_sql_text || '               (SELECT MIN(Gp1.Start_Date)';

Line: 310

  lv_sql_text := lv_sql_text || '           AND (SELECT Gp2.End_Date';

Line: 441

  lv_pi_cursor_sql := ' SELECT  DISTINCT Gp.Period_Num Accounting_Period_Num, Gp.Period_Name Accounting_Period ';

Line: 451

  lv_pi_cursor_sql :=  lv_pi_cursor_sql || ' SELECT MIN(Gp1.Start_Date)  ';

Line: 459

  lv_pi_cursor_sql :=  lv_pi_cursor_sql || ' SELECT MAX(Gp2.End_Date) ';

Line: 467

  lv_bi_cursor_sql := 'SELECT DISTINCT *'; ----fixed bug 10316565 by ChuanLing Shao

Line: 470

  lv_bi_cursor_sql := lv_bi_cursor_sql || '  FROM (SELECT ';

Line: 495

  lv_bi_cursor_sql := lv_bi_cursor_sql || '           AND EXISTS (SELECT llbg.Bal_Seg_Value ';

Line: 506

  lv_bi_cursor_sql := lv_bi_cursor_sql || '               (SELECT MIN(Gp1.Start_Date)';

Line: 511

  lv_bi_cursor_sql := lv_bi_cursor_sql || '           AND (SELECT MAX(Gp2.End_Date)';

Line: 528

  lv_bi_cursor_sql := lv_bi_cursor_sql || '               (SELECT Gp1.Start_Date';

Line: 533

  lv_bi_cursor_sql := lv_bi_cursor_sql || '           AND (SELECT Gp2.End_Date';