APPS.GL_OPEN_BAL_REVAL_RPT_PKG SQL Statements

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

Line: 45

  SELECT
        MAX(CASE gp.period_name WHEN period_from_param THEN gp.start_date END)
       ,MAX(CASE gp.period_name WHEN period_to_param THEN gp.end_date END)
  INTO
        gd_start_date
       ,gd_end_date
  FROM
        gl_periods gp
       ,gl_ledgers gll
  WHERE
            gll.ledger_id=ledger_id_param
        AND gp.period_set_name =gll.period_set_name
        AND gp.period_name IN (period_from_param,period_to_param);

Line: 96

  SELECT   MAX(gjh.je_header_id)
  INTO     ln_reval_header_id
  FROM
            gl_je_headers gjh
           ,gl_je_lines   gjl
  WHERE
	           gjh.status = 'P'
           AND gjh.actual_flag = 'A'
           AND gjh.ledger_id = ledger_id_param
           AND gjh.je_source = 'Revaluation'
           AND gjl.je_header_id = gjh.je_header_id
           AND gjl.code_combination_id = p_code_combination_id
           AND gjh.currency_code=p_currency
           AND gjh.period_name=period_to_param;

Line: 126

    SELECT currency_conversion_rate
    INTO ln_reval_conversion_rate
    FROM gl_je_headers
    WHERE je_header_id=ln_reval_header_id;

Line: 139

    SELECT name
    INTO lc_access_set_name
    FROM gl_access_sets
    WHERE access_set_id=access_set_id_param;

Line: 150

    SELECT name
    INTO lc_ledger_name
    FROM gl_ledgers
    WHERE ledger_id=ledger_id_param;