APPS.JA_CN_PS_CYB_EXPORT_PKG SQL Statements

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

Line: 85

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

Line: 110

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

Line: 121

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

Line: 126

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

Line: 261

  DELETE
    FROM   JA_CN_LEDGER_LE_BSV_GT;

Line: 287

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

Line: 297

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

Line: 305

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

Line: 317

  lv_bi_cursor_sql := 'SELECT DISTINCT *'; ----fixed bug 10316565 by ChuanLing Shao as ChaoQun's great help

Line: 320

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

Line: 348

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

Line: 359

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

Line: 365

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