APPS.GL_FORMSINFO SQL Statements

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

Line: 22

      SELECT segment_num, application_column_name
      FROM fnd_id_flex_segments
      WHERE application_id = 101
      AND   id_flex_code   = 'GL#'
      AND   enabled_flag   = 'Y'
      AND   id_flex_num    = x_chart_of_accounts_id
      ORDER BY segment_num;

Line: 113

      SELECT
	     name,
  	     enabled_flag,
             security_segment_code,
             chart_of_accounts_id,
             period_set_name,
             accounted_period_type,
             automatically_created_flag
      FROM
	     GL_ACCESS_SETS
      WHERE
	     access_set_id = X_access_set_id;

Line: 153

      SELECT access_privilege_code
      FROM   gl_access_set_ledgers
      WHERE  access_set_id = X_access_set_id
      AND    ledger_id = X_ledger_id
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 162

      SELECT decode(max(decode(access_privilege_code, 'B', 2, 1)), 1, 'R', 2, 'B', 'N')
      FROM   gl_access_set_assignments
      WHERE  access_set_id = X_access_set_id
      AND    segment_value = X_segment_value
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 171

      SELECT access_privilege_code
      FROM   gl_access_set_assignments
      WHERE  access_set_id = X_access_set_id
      AND    ledger_id = X_ledger_id
      AND    segment_value = X_segment_value
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 221

      SELECT object_type_code
      FROM   gl_ledgers
      WHERE  ledger_id = X_ledger_id;

Line: 251

      SELECT asl.ledger_id
      FROM   gl_access_set_ledgers asl
      WHERE  asl.access_set_id = X_access_set_id
      AND    asl.ledger_id = (select gas.default_ledger_id
                              from   gl_access_sets gas
	                      where  gas.access_set_id = asl.access_set_id)
      AND    (   (    (X_access_privilege_code = 'F')
                  AND (asl.access_privilege_code = 'F'))
              OR (    (X_access_privilege_code = 'B')
                  AND (asl.access_privilege_code IN ('F', 'B')))
              OR ( X_access_privilege_code = 'R'))
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(asl.start_date),trunc(X_edate)-1)
                                 AND nvl(trunc(asl.end_date), trunc(X_edate)+1)));

Line: 267

      SELECT distinct ledger_id
      FROM   gl_access_set_ledgers
      WHERE  access_set_id = X_access_set_id
      AND    (   (    (X_access_privilege_code = 'F')
                  AND (access_privilege_code = 'F'))
              OR (    (X_access_privilege_code = 'B')
                  AND (access_privilege_code IN ('F', 'B')))
              OR ( X_access_privilege_code = 'R'))
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 329

      SELECT count(*)
      FROM   gl_access_set_ledgers
      WHERE  access_set_id = X_access_set_id
      AND    rownum < 3;

Line: 347

      SELECT nvl(max(1),0)
      FROM   gl_access_set_ledgers
      WHERE  access_set_id = X_access_set_id
      AND    access_privilege_code in ('W', 'F')
      AND    rownum < 2;

Line: 410

      SELECT
	     name,
	     short_name,
	     chart_of_accounts_id,
	     currency_code,
	     period_set_name,
	     accounted_period_type,
	     ret_earn_code_combination_id,
	     suspense_allowed_flag,
	     allow_intercompany_post_flag,
             enable_average_balances_flag,
	     enable_budgetary_control_flag,
	     require_budget_journals_flag,
             enable_je_approval_flag,
	     enable_automatic_tax_flag,
             consolidation_ledger_flag,
             translate_eod_flag,
             translate_qatd_flag,
             translate_yatd_flag,
             automatically_created_flag,
	     track_rounding_imbalance_flag,
             enable_reconciliation_flag,
	     alc_ledger_type_code,
             object_type_code,
             le_ledger_type_code,
             bal_seg_value_option_code,
             bal_seg_column_name,
             mgt_seg_value_option_code,
             mgt_seg_column_name,
	     description,
	     latest_opened_period_name,
	     latest_encumbrance_year,
	     future_enterable_periods_limit,
	     cum_trans_code_combination_id,
	     res_encumb_code_combination_id,
             net_income_code_combination_id,
             rounding_code_combination_id,
             transaction_calendar_id,
             daily_translation_rate_type,
             period_average_rate_type,
             period_end_rate_type,
             ledger_category_code
      FROM
	     GL_LEDGERS
      WHERE
	     ledger_id = X_ledger_id;

Line: 520

      SELECT bal_seg_value_option_code
      FROM gl_ledgers
      WHERE ledger_id = X_ledger_id;

Line: 525

      SELECT 'Valid'
      FROM   gl_ledger_segment_values
      WHERE  ledger_id = X_ledger_id
      AND    segment_type_code = 'B'
      AND    segment_value = X_bsv
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 566

      SELECT mgt_seg_value_option_code
      FROM gl_ledgers
      WHERE ledger_id = X_ledger_id;

Line: 571

      SELECT 'Valid'
      FROM   gl_ledger_segment_values
      WHERE  ledger_id = X_ledger_id
      AND    segment_type_code = 'M'
      AND    segment_value = X_msv
      AND    (   (X_edate IS NULL)
              OR (trunc(X_edate) BETWEEN nvl(trunc(start_date), trunc(X_edate)-1)
                                 AND nvl(trunc(end_date), trunc(X_edate)+1)));

Line: 608

      SELECT nvl(multi_org_flag, 'N')
      FROM fnd_product_groups;

Line: 659

    gl_iea_subsidiary_pkg.select_columns(
      x_subsidiary_id,
      x_name,
      x_chart_of_accounts_id,
      x_ledger_id,
      x_enabled_flag,
      x_subsidiary_type_code,
      x_company_value,
      x_currency_code,
      x_autoapprove_flag,
      x_view_partner_lines_flag,
      x_conversion_type_code,
      x_conversion_type,
      x_remote_instance_flag,
      x_transfer_ledger_id,
      x_transfer_currency_code,
      x_contact,
      x_notification_threshold);

Line: 687

    gl_system_usages_pkg.select_columns(x_average_balances_flag,
                                        x_consolidation_ledger_flag);

Line: 709

           SELECT 'x' INTO dummy
           FROM gl_iea_subsidiaries
           WHERE  subsidiary_id = X_Subsidiary_Id
           AND    enabled_flag = 'Y';

Line: 738

    SELECT s.sid
    INTO sid
    FROM v$session s, v$process p
    WHERE s.paddr = p.addr
    AND   audsid = USERENV('SESSIONID');

Line: 750

    SELECT s.serial#
    INTO sid
    FROM v$session s, v$process p
    WHERE s.paddr = p.addr
    AND   audsid = USERENV('SESSIONID');