APPS.GL_RJE_ACCESS_PKG SQL Statements

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

Line: 7

                                       x_selected_ced DATE) RETURN BOOLEAN IS
-- x_batch_id is recurring batch id, x_selected_ced is the calculation
-- effective date

  CURSOR formulas (num NUMBER) IS
    SELECT  recurring_header_id
      FROM  gl_recurring_headers
     WHERE  recurring_batch_id = x_batch_id
       AND  rownum <= num;

Line: 34

      SELECT   nvl(ru.ledger_id, hd.ledger_id)
        INTO   lgr_id
        FROM   gl_recurring_line_calc_rules ru, gl_recurring_headers hd
       WHERE   hd.recurring_header_id = next_formula.recurring_header_id
         AND   hd.recurring_header_id = ru.recurring_header_id(+)
         AND   rownum <2;

Line: 47

        if (x_selected_ced > end_date
            OR x_selected_ced < start_date) then
          RETURN FALSE;

Line: 61

      SELECT 'non consolidation ledger exist'
      FROM   gl_recurring_headers hd,
             gl_ledgers lgr
      WHERE  hd.recurring_header_id = formula_id
      AND    lgr.ledger_id  =  hd.ledger_id
      AND    lgr.consolidation_ledger_flag = 'N'
      AND    rownum < 2;

Line: 70

      SELECT recurring_header_id
      FROM   gl_recurring_headers
      WHERE  recurring_batch_id = x_batch_id
      AND    rownum <= num;

Line: 108

    SELECT  ledger_id
      FROM  gl_recurring_headers
     WHERE  recurring_batch_id = x_allocation_batch_id;