APPS.GL_INFO SQL Statements

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

Line: 12

 	select start_date, end_date
 	into   tstart_date, tend_date
 	from gl_period_statuses
 	where period_name = tperiod_name
 	and ledger_id = tledger_id
 	and application_id = 101;

Line: 43

    select name, chart_of_accounts_id, currency_code
    into ledname, coaid, func_curr
    from gl_ledgers
    where ledger_id = ledid;

Line: 69

      select bv.budget_name
      into name
      from gl_budget_versions bv
      where bv.budget_version_id = type_id;

Line: 75

      select e.encumbrance_type
      into name
      from gl_encumbrance_types e
      where e.encumbrance_type_id = type_id;

Line: 109

    select decode(lmode, 'M', meaning, description)
    into value
    from gl_lookups
    where lookup_code = code
    and   lookup_type = type;

Line: 136

    SELECT  a.period_name
    INTO    tfirst_period
    FROM    gl_period_statuses a, gl_period_statuses b
    WHERE   a.application_id = 101
    AND     b.application_id = 101
    AND     a.ledger_id =tledger_id
    AND     b.ledger_id = tledger_id
    AND     a.period_type = b.period_type
    AND     a.period_year = b.period_year
    AND     b.period_name = tperiod_name
    AND     a.period_num =
           (SELECT min(c.period_num)
              FROM gl_period_statuses c
             WHERE c.application_id = 101
               AND c.ledger_id =tledger_id
               AND c.period_year = a.period_year
               AND c.period_type = a.period_type
          GROUP BY c.period_year);

Line: 177

    SELECT  a.period_name
    INTO    tfirst_period
    FROM    gl_period_statuses a, gl_period_statuses b
    WHERE   a.application_id = 101
    AND     b.application_id = 101
    AND     a.ledger_id =tledger_id
    AND     b.ledger_id = tledger_id
    AND     a.period_type = b.period_type
    AND     a.period_year = b.period_year
    AND     a.quarter_num = b.quarter_num
    AND     b.period_name = tperiod_name
    AND     a.period_num =
           (SELECT min(c.period_num)
              FROM gl_period_statuses c
             WHERE c.application_id = 101
               AND c.ledger_id = tledger_id
               AND c.period_year = a.period_year
	       AND c.quarter_num = a.quarter_num
               AND c.period_type = a.period_type
          GROUP BY c.period_year,c.quarter_num);

Line: 221

    select glc.name, glc.method, glc.from_currency_code,
           glc.from_ledger_id, glc.to_ledger_id,
           glc.description
    into cons_name, method, curr_code, from_ledid, to_ledid,
         description
    from gl_consolidation glc
    where glc.consolidation_id = cons_id;