APPS.JA_CN_PS_BE_EXPORT_PKG SQL Statements

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

Line: 121

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

Line: 156

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

Line: 168

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

Line: 181

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

Line: 306

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

Line: 334

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

Line: 347

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

Line: 358

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

Line: 494

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

Line: 504

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

Line: 512

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

Line: 520

  lv_bi_cursor_sql := 'SELECT DISTINCT *';

Line: 523

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

Line: 545

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

Line: 556

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

Line: 562

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

Line: 580

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

Line: 585

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