APPS.GL_SEL_SEG_TURNOVER_RPT_PKG SQL Statements

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

Line: 13

  SELECT gl1.object_type_code
  INTO   lc_ledger_obj_type
  FROM   gl_ledgers gl1
  WHERE  gl1.ledger_id = p_ledger_id;

Line: 21

    SELECT gl1.ledger_id
    INTO   ln_single_ledger_id
    FROM   gl_ledger_set_assignments glsa
          ,gl_ledgers                gl1
    WHERE  glsa.ledger_set_id   = p_ledger_id
    AND    gl1.ledger_id        = glsa.ledger_id
    AND    gl1.object_type_code = 'L'
    AND    ROWNUM               = 1;

Line: 31

  SELECT gps.effective_period_num
  INTO   x_per_eff_num
  FROM   gl_period_statuses gps
  WHERE  gps.period_name    = p_period_name
  AND    gps.ledger_id      = ln_single_ledger_id
  AND    gps.application_id = 101;

Line: 57

    SELECT SUBSTR(aba.description,1,2)||'/'||
           SUBSTR(csh.statement_number,1,4)||'/'||
           SUBSTR(TO_CHAR(csl.line_number),1,4)
    INTO   lc_doc_num
    FROM   gl_import_references gir
          ,ce_statement_lines   csl
          ,ce_statement_headers csh
          ,ap_bank_accounts     aba
    WHERE  gir.je_header_id        = p_je_header_id
    AND    gir.je_line_num         = p_je_line_num
    AND    gir.reference_3         = csl.statement_line_id
    AND    csh.statement_header_id = csl.statement_header_id
    AND    csh.bank_account_id     = aba.bank_account_id;

Line: 73

      SELECT ai.doc_sequence_value
      INTO   lc_doc_num
      FROM   gl_import_references gir
            ,ap_invoices          ai
      WHERE  gir.je_header_id = p_je_header_id
      AND    gir.je_line_num  = p_je_line_num
      AND    gir.reference_6  = 'AP Invoices'
      AND    gir.reference_2  = ai.invoice_id;

Line: 84

          SELECT TO_CHAR(gir.reference_4)
          INTO   lc_doc_num
          FROM   gl_import_references gir
          WHERE  gir.je_header_id = p_je_header_id
          AND    gir.je_line_num  = p_je_line_num
          AND    (gir.reference_6 IN ('INV','DM','DEP','CM','AP Payments','AP Reconciled Payments','CUSTOMER','DIALOG_HK')
              OR gir.reference_10 IN ('AR_CASH_RECEIPT_HISTORY','AR_RECEIVABLE_APPLICATIONS'));

Line: 118

    SELECT  fifseg.segment_name
    INTO    lc_segment_name
    FROM    fnd_id_flex_structures   fifs
           ,fnd_id_flex_segments     fifseg
    WHERE   fifs.id_flex_code       =  fifseg.id_flex_code
    AND     fifs.id_flex_num        =  fifseg.id_flex_num
    AND     fifs.application_id     =  fifseg.application_id
    AND     fifseg.id_flex_code     =  'GL#'
    AND     fifseg.id_flex_num      =  p_coa_id_in
    AND     fifseg.application_id   =  101
    AND     fifseg.segment_num      =  p_ctrl_seg_num_in;

Line: 169

  GC_BEGIN_DR_SELECT  := 'SUM(DECODE(gps.effective_period_num, '||GC_PER_EFF_FROM_NUM||', NVL(gb.begin_balance_dr,0), 0))';

Line: 170

  GC_BEGIN_CR_SELECT  := 'SUM(DECODE(gps.effective_period_num, '||GC_PER_EFF_FROM_NUM||', NVL(gb.begin_balance_cr,0), 0))';

Line: 171

  GC_PERIOD_DR_SELECT := 'SUM(NVL(gb.period_net_dr,0))';

Line: 172

  GC_PERIOD_CR_SELECT := 'SUM(NVL(gb.period_net_cr,0))';

Line: 177

      GC_BEGIN_DR_SELECT  := 'SUM(NVL(DECODE(gps.effective_period_num, '||GC_PER_EFF_FROM_NUM||', DECODE(gb.translated_flag,''R'',gb.begin_balance_dr,gb.begin_balance_dr_beq),0), 0))';

Line: 178

      GC_BEGIN_CR_SELECT  := 'SUM(NVL(DECODE(gps.effective_period_num, '||GC_PER_EFF_FROM_NUM||', DECODE(gb.translated_flag,''R'',gb.begin_balance_cr,gb.begin_balance_cr_beq),0), 0))';

Line: 179

      GC_PERIOD_DR_SELECT := 'SUM(NVL(DECODE(gb.translated_flag,''R'',gb.period_net_dr,gb.period_net_dr_beq),0))';

Line: 180

      GC_PERIOD_CR_SELECT := 'SUM(NVL(DECODE(gb.translated_flag,''R'',gb.period_net_cr,gb.period_net_cr_beq),0))';

Line: 183

  GC_NONZERO_WHERE := ' ( '||GC_PERIOD_DR_SELECT||' <> 0 OR '||GC_PERIOD_CR_SELECT||' <> 0)';

Line: 316

  SELECT gas.name
  INTO   gc_data_access_set_name
  FROM   gl_access_sets  gas
  WHERE  gas.access_set_id  = ACCESS_SET_ID_PARAM;