APPS.GL_SRS_INCREMENTOR_API SQL Statements

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

Line: 32

         SELECT   transaction_date
             FROM gl_transaction_dates
            WHERE transaction_calendar_id = v_trxn_calendar_id
              AND business_day_flag = 'Y'
              AND transaction_date > v_new_anchor_date
         ORDER BY transaction_date ASC;

Line: 40

         SELECT   transaction_date
             FROM gl_transaction_dates
            WHERE transaction_calendar_id = v_trxn_calendar_id
              AND business_day_flag = 'Y'
              AND transaction_date < v_new_anchor_date
         ORDER BY transaction_date DESC;

Line: 48

         SELECT business_day_flag
           FROM gl_transaction_dates
          WHERE transaction_calendar_id = v_trxn_calendar_id
            AND transaction_date = CURRENT_DATE;

Line: 58

      SELECT transaction_calendar_id
        INTO v_trxn_calendar_id
        FROM gl_ledgers
       WHERE ledger_id = x_ledger_id;

Line: 96

         SELECT COUNT(*)
           INTO days_offset
           FROM gl_transaction_dates
          WHERE transaction_calendar_id = v_trxn_calendar_id
            AND business_day_flag = 'Y'
            AND transaction_date >= v_last_para_date
            AND transaction_date < v_last_anchor_date;

Line: 121

         SELECT COUNT(*)
           INTO days_offset
           FROM gl_transaction_dates
          WHERE transaction_calendar_id = v_trxn_calendar_id
            AND business_day_flag = 'Y'
            AND transaction_date > v_last_anchor_date
            AND transaction_date <= v_last_para_date;

Line: 157

      SELECT period_name
        INTO x_new_para_period
        FROM gl_date_period_map m, gl_ledgers b
       WHERE m.period_set_name = b.period_set_name
         AND m.period_type = b.accounted_period_type
         AND b.ledger_id = x_ledger_id
         AND m.accounting_date = x_new_para_date;

Line: 219

         SELECT   period_name
             FROM gl_period_statuses
            WHERE application_id = 101
              AND ledger_id = x_ledger_id
              AND adjustment_period_flag = 'N'
              AND effective_period_num >= c_start_period_num
         ORDER BY effective_period_num ASC;

Line: 228

         SELECT   period_name
             FROM gl_period_statuses
            WHERE application_id = 101
              AND ledger_id = x_ledger_id
              AND adjustment_period_flag = 'N'
              AND effective_period_num <= c_start_period_num
         ORDER BY effective_period_num DESC;

Line: 244

      SELECT effective_period_num
        INTO l_eff_period_num
        FROM gl_period_statuses p
       WHERE p.application_id = 101
         AND p.ledger_id = x_ledger_id
         AND p.period_name = x_period_last_run
         AND p.adjustment_period_flag = 'N';

Line: 261

      SELECT effective_period_num, period_name
        INTO l_start_period_num, dummy
        FROM gl_period_statuses p
       WHERE p.application_id = 101
         AND p.ledger_id = x_ledger_id
         AND x_start_date_last_run BETWEEN p.start_date
                                       AND   p.end_date
                                           + 0.99998843
         AND p.adjustment_period_flag = 'N';

Line: 283

      SELECT effective_period_num, period_name
        INTO c_start_period_num, c_start_period
        FROM gl_period_statuses p
       WHERE p.application_id = 101
         AND p.ledger_id = x_ledger_id
         AND x_start_date_this_run BETWEEN p.start_date
                                       AND   p.end_date
                                           + 0.99998843
         AND p.adjustment_period_flag = 'N';

Line: 303

         SELECT COUNT(*)
           INTO period_offset
           FROM gl_period_statuses p
          WHERE p.application_id = 101
            AND p.ledger_id = x_ledger_id
            AND p.effective_period_num BETWEEN l_start_period_num
                                           AND l_eff_period_num
            AND p.adjustment_period_flag = 'N';

Line: 327

         SELECT COUNT(*)
           INTO period_offset
           FROM gl_period_statuses p
          WHERE p.application_id = 101
            AND p.ledger_id = x_ledger_id
            AND p.effective_period_num BETWEEN l_eff_period_num
                                           AND l_start_period_num
            AND p.adjustment_period_flag = 'N';

Line: 464

      SELECT start_date
        INTO v_pstart_date
        FROM gl_period_statuses
       WHERE application_id = 101
         AND ledger_id = x_ledger_id
         AND period_name = v_period;

Line: 717

        SELECT batch_id,batch_type_code
        FROM gl_auto_alloc_batches
        WHERE allocation_set_id = v_batch_id
        AND batch_type_code IN ('A','R','E','B');

Line: 737

      SELECT consolidation_ledger_flag
      into con_ledger_flag
      FROM gl_system_usages;

Line: 778

           SELECT lgr.ledger_id
           into v_adb_ledger_id
           FROM gl_recurring_headers rh, gl_ledgers lgr
           WHERE rh.recurring_batch_id = v_batch_id
           AND   lgr.ledger_id = rh.ledger_id
           AND   lgr.enable_average_balances_flag = 'Y'
           AND   lgr.consolidation_ledger_flag = 'N'
           AND   rownum = 1;

Line: 793

           SELECT lgr.ledger_id
           into  v_con_ledger_id
           FROM gl_recurring_headers rh, gl_ledgers lgr
           WHERE rh.recurring_batch_id = v_batch_id
           AND   lgr.ledger_id = rh.ledger_id
           AND   lgr.enable_average_balances_flag = 'Y'
           AND   lgr.consolidation_ledger_flag = 'Y'
           AND   rownum =1;

Line: 874

           SELECT lgr.ledger_id
           into v_adb_ledger_id
           FROM   gl_alloc_formulas af,
                  gl_alloc_formula_lines al,
                  gl_ledger_set_assignments lsa,
                  gl_ledgers lgr
           WHERE  af.allocation_batch_id = v_batch_id
           AND    al.allocation_formula_id = af.allocation_formula_id
           AND    al.line_number IN (4, 5)
           AND    lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
           AND    sysdate BETWEEN
                       nvl(trunc(lsa.start_date), sysdate - 1)
                   AND nvl(trunc(lsa.end_date), sysdate + 1)
           AND    lgr.ledger_id = nvl(lsa.ledger_id,
                              nvl(al.ledger_id,v_ledger_id))
           AND    lgr.object_type_code = 'L'
           AND    lgr.enable_average_balances_flag= 'Y'
           AND    lgr.consolidation_ledger_flag = 'N'
           AND    rownum = 1;

Line: 900

           SELECT lgr.ledger_id
           into v_con_ledger_id
           FROM   gl_alloc_formulas af,
                  gl_alloc_formula_lines al,
                  gl_ledger_set_assignments ls,
                  gl_ledgers lgr
           WHERE  af.allocation_batch_id = v_batch_id
           AND    al.allocation_formula_id = af.allocation_formula_id
           AND    al.line_number IN (4, 5)
           AND    ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
           AND    sysdate BETWEEN
                       nvl(trunc(ls.start_date), sysdate - 1)
                   AND nvl(trunc(ls.end_date), sysdate + 1)
           AND    lgr.ledger_id = nvl(ls.ledger_id,
                                  nvl(al.ledger_id,v_ledger_id))
           AND    lgr.object_type_code = 'L'
           AND    lgr.enable_average_balances_flag = 'Y'
           AND    lgr.consolidation_ledger_flag = 'Y'
           AND    rownum = 1;

Line: 1001

                   SELECT lgr.ledger_id
                   into v_adb_ledger_id
                   FROM   gl_alloc_formulas af,
                          gl_alloc_formula_lines al,
                          gl_ledger_set_assignments lsa,
                          gl_ledgers lgr
                   WHERE  af.allocation_batch_id = current_bid
                   AND    al.allocation_formula_id = af.allocation_formula_id
                   AND    al.line_number IN (4, 5)
                   AND    lsa.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
                   AND    sysdate BETWEEN
                           nvl(trunc(lsa.start_date), sysdate - 1)
                       AND nvl(trunc(lsa.end_date), sysdate + 1)
                   AND    lgr.ledger_id = nvl(lsa.ledger_id,
                              nvl(al.ledger_id,v_ledger_id))
                   AND    lgr.object_type_code = 'L'
                   AND    lgr.enable_average_balances_flag = 'Y'
                   AND    lgr.consolidation_ledger_flag = 'N'
                   AND    rownum = 1;

Line: 1029

                   SELECT lgr.ledger_id
                   into v_con_ledger_id
                   FROM   gl_alloc_formulas af,
                          gl_alloc_formula_lines al,
                          gl_ledger_set_assignments ls,
                          gl_ledgers lgr
                   WHERE  af.allocation_batch_id = current_bid
                   AND    al.allocation_formula_id = af.allocation_formula_id
                   AND    al.line_number IN (4, 5)
                   AND    ls.ledger_set_id (+) = nvl(al.ledger_id,v_ledger_id)
                   AND    sysdate BETWEEN
                              nvl(trunc(ls.start_date), sysdate - 1)
                          AND nvl(trunc(ls.end_date), sysdate + 1)
                   AND    lgr.ledger_id = nvl(ls.ledger_id,
                                  nvl(al.ledger_id,v_ledger_id))
                   AND    lgr.object_type_code = 'L'
                   AND    lgr.enable_average_balances_flag = 'Y'
                   AND    lgr.consolidation_ledger_flag = 'Y'
                   AND    rownum = 1;

Line: 1061

                   SELECT lgr.ledger_id
                   into v_adb_ledger_id
                   FROM gl_recurring_headers rh, gl_ledgers lgr
                   WHERE rh.recurring_batch_id = current_bid
                   AND   lgr.ledger_id = rh.ledger_id
                   AND   lgr.enable_average_balances_flag = 'Y'
                   AND   lgr.consolidation_ledger_flag = 'N'
                   AND   rownum = 1;

Line: 1078

                   SELECT lgr.ledger_id
                   into  v_con_ledger_id
                   FROM gl_recurring_headers rh, gl_ledgers lgr
                   WHERE rh.recurring_batch_id = current_bid
                   AND   lgr.ledger_id = rh.ledger_id
                   AND   lgr.enable_average_balances_flag = 'Y'
                   AND   lgr.consolidation_ledger_flag = 'Y'
                   AND   rownum =1;

Line: 1218

            SELECT period_name
              INTO c_start_period
              FROM gl_period_statuses p
             WHERE p.application_id = 101
               AND p.ledger_id = x_ledger_id
               AND c_date BETWEEN p.start_date
                              AND p.end_date + 0.99998843
               AND p.adjustment_period_flag = 'N';

Line: 1266

      SELECT batch_id,batch_type_code
      FROM   gl_auto_alloc_batches
      WHERE  allocation_set_id = x_batch_id;

Line: 1271

      SELECT ledger_id
      FROM   gl_recurring_headers
      WHERE  recurring_batch_id = random_bid;

Line: 1277

      SELECT lgr.ledger_id
      FROM   gl_alloc_formulas af,
             gl_alloc_formula_lines afl,
             gl_ledger_set_assignments lsa,
             gl_ledgers lgr
      WHERE  af.allocation_batch_id = random_bid
      AND    afl.allocation_formula_id = af.allocation_formula_id
      AND    afl.line_number IN (4, 5)
      AND    lsa.ledger_set_id (+) = nvl(afl.ledger_id, x_ledger_id)
      AND    sysdate BETWEEN
                     nvl(trunc(lsa.start_date), sysdate - 1)
                 AND nvl(trunc(lsa.end_date), sysdate + 1)
      AND    lgr.ledger_id = nvl(lsa.ledger_id,
                                 nvl(afl.ledger_id, x_ledger_id))
      AND    lgr.object_type_code = 'L';

Line: 1294

      SELECT lgr.ledger_id
      FROM   gl_alloc_formulas af,
             gl_alloc_formula_lines afl,
             gl_ledger_set_assignments lsa,
             gl_ledgers lgr
      WHERE  af.allocation_batch_id = random_bid
      AND    afl.allocation_formula_id = af.allocation_formula_id
      AND    afl.line_number IN (4, 5)
      AND    lsa.ledger_set_id (+) = afl.ledger_id
      AND    sysdate BETWEEN
                     nvl(trunc(lsa.start_date), sysdate - 1)
                 AND nvl(trunc(lsa.end_date), sysdate + 1)
      AND    lgr.ledger_id = nvl(lsa.ledger_id, afl.ledger_id)
      AND    lgr.object_type_code = 'L';