APPS.JA_CN_PS_FA_BI_EXP_PKG SQL Statements

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

Line: 69

SELECT
  DISTINCT fcb.asset_cost_acct
FROM
  fa_book_controls_sec fbcs
, fa_category_books    fcb
, fa_additions_v       fav
WHERE  fbcs.book_type_code = fcb.book_type_code
  AND  fbcs.set_of_books_id = pn_ledger
  AND  fbcs.book_class IN ('CORPORATE', 'TAX')
  AND  fbcs.gl_posting_allowed_flag = 'YES'
  AND  fav.asset_category_id = fcb.category_id
  AND  fav.asset_type = 'CAPITALIZED'
  AND  fav.asset_id IN
        (SELECT
           DISTINCT fdh.asset_id
         FROM
           fa_distribution_history fdh
         , fa_transaction_headers  fth
         WHERE  fdh.asset_id = fth.asset_id
           AND  fth.transaction_type_code NOT IN ('FULL RETIREMENT')
           AND  EXISTS
           (
            SELECT
              fdp.period_close_date
            FROM
              fa_deprn_periods fdp
            WHERE  fdp.book_type_code = fbcs.book_type_code
              AND  fdp.calendar_period_close_date
                BETWEEN pd_start_date AND pd_end_date
              AND    fdp.period_close_date IS NOT NULL
           )
           AND  fdh.date_effective <
                nvl((SELECT MAX(fdp.period_close_date)
                     FROM   fa_deprn_periods fdp
                     WHERE  fdp.book_type_code = fbcs.book_type_code
                     AND    fdp.calendar_period_close_date <= pd_end_date
                     AND    fdp.period_close_date IS NOT NULL),
                     SYSDATE)
           AND  (
                fdh.date_ineffective >
                nvl((SELECT MAX(fdp.period_close_date)
                     FROM   fa_deprn_periods fdp
                     WHERE  fdp.book_type_code = fbcs.book_type_code
                     AND    fdp.calendar_period_close_date <= pd_end_date
                     AND    fdp.period_close_date IS NOT NULL),
                     SYSDATE) OR fdh.date_ineffective IS NULL
                )
           AND    EXISTS
            (
            SELECT jclllbg.bal_seg_value
              FROM ja_cn_ledger_le_bsv_gt jclllbg
             WHERE JA_CN_CFS_DATA_CLT_PKG.
                    get_balancing_segment(fdh.code_combination_id) =
                        jclllbg.bal_seg_value
               AND  jclllbg.ledger_id = pn_ledger
               AND  jclllbg.legal_entity_id = pn_legal_entity
            )
          )
ORDER  BY fcb.asset_cost_acct;

Line: 156

    SELECT
      start_date
    INTO
      ld_start_date
    FROM
      gl_period_statuses
    WHERE ledger_id = pn_ledger_id
      AND application_id = 101
      AND period_name = pv_period_from
      AND to_char(period_year) = pv_accounting_year;

Line: 172

    SELECT
      end_date
    INTO
      ld_end_date
    FROM
      gl_period_statuses
    WHERE ledger_id = pn_ledger_id
      AND application_id = 101
      AND period_name = pv_period_to
      AND to_char(period_year) = pv_accounting_year;