APPS.OKL_ACCOUNTING_UTIL SQL Statements

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

Line: 39

    SELECT flex_value_set_id
	FROM fnd_id_flex_segments
    WHERE id_flex_num = p_chart_of_account_id
	AND application_id = 101
	AND id_flex_code = 'GL#'
    AND enabled_flag = 'Y'
    ORDER BY segment_num;

Line: 72

    SELECT parent_flex_value_set_id
    FROM fnd_flex_value_sets
    WHERE flex_value_set_id = l_flex_value_set_id;

Line: 83

    SELECT description
    FROM fnd_flex_values_vl
    WHERE flex_value_set_id = l_flex_value_set_id
    AND flex_value = l_segment_value;

Line: 96

    SELECT description
    FROM fnd_flex_values_vl
    WHERE flex_value_set_id = l_flex_value_set_id
    AND flex_value = l_segment_value
    AND parent_flex_value_low  = l_parent_value_low;

Line: 189

    SELECT '1'
    FROM fnd_lookup_values flv,
    	 fnd_lookup_types flt
    WHERE
    	flv.lookup_type = p_lookup_type
    AND flv.view_application_id = p_view_app_id
    AND flv.lookup_code = p_lookup_code
    AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
    AND flv.LANGUAGE = USERENV('LANG')
    AND flv.enabled_flag = 'Y'
    AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)
    AND flv.lookup_type = flt.lookup_type
    AND flv.view_application_id = flt.view_application_id
    AND flv.security_group_id = flt.security_group_id
    AND flt.application_id = p_app_id;

Line: 325

  SELECT '1'
  FROM fnd_currencies_vl
  WHERE currency_code = p_currency_code
  AND ENABLED_FLAG = 'Y'
  AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
  AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 362

      SELECT chart_of_accounts_id
      FROM GL_LEDGERS_PUBLIC_V
      WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);

Line: 367

      SELECT '1'
      FROM gl_code_combinations
      WHERE code_combination_id = p_ccid
      AND chart_of_accounts_id = l_chart_of_accounts_id
      AND ENABLED_FLAG = 'Y'
      AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
      AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 409

    SELECT closing_status
    FROM gl_period_statuses
    WHERE application_id = 540
    AND ledger_id = l_ledger_id
    AND period_name = p_period_name;

Line: 445

    SELECT closing_status
    FROM gl_period_statuses
    WHERE application_id = 101
    AND ledger_id = l_ledger_id
    AND period_name = p_period_name;

Line: 485

    SELECT period_set_name, accounted_period_type
    FROM GL_LEDGERS_PUBLIC_V
    WHERE ledger_id = l_ledger_id;

Line: 490

    SELECT period_name, start_date, end_date
    FROM gl_periods
    WHERE TRUNC(start_date) <= TRUNC(p_date)
    AND TRUNC(end_date) >= TRUNC(p_date)
    AND period_set_name = l_period_set_name
    AND period_type = l_user_period_type
-- Added by Santonyr on 24-Dec-2002 for the bug fix 2675596
    AND NVL(ADJUSTMENT_PERIOD_FLAG, 'N') = 'N';

Line: 535

    SELECT period_set_name, accounted_period_type
    FROM GL_LEDGERS_PUBLIC_V
    WHERE ledger_id = l_ledger_id;

Line: 540

    SELECT start_date, end_date
    FROM gl_periods
    WHERE period_name = p_period_name
    AND period_set_name = l_period_set_name
    AND period_type = l_user_period_type;

Line: 575

	  l_select_string VARCHAR2(500);

Line: 586

	    l_select_string := ' SELECT ''1'' FROM ' || p_source_table || ' WHERE id = :l_id ' ;

Line: 588

          EXECUTE IMMEDIATE l_select_string
            INTO l_found
            USING p_source_id;

Line: 635

    SELECT set_of_books_id
    FROM OKL_SYS_ACCT_OPTS;

Line: 639

    SELECT ledger_id
    FROM okl_representations_v
    WHERE representation_type = 'SECONDARY';

Line: 668

    SELECT name
    FROM GL_LEDGERS_PUBLIC_V
    WHERE ledger_id =  p_set_of_books_id;

Line: 700

    SELECT ael_rounding_rule
    FROM OKL_SYS_ACCT_OPTS;

Line: 704

    SELECT PRECISION
    FROM fnd_currencies_vl
    WHERE currency_code = p_currency_code
    AND enabled_flag = 'Y'
    AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 779

    SELECT cc_rounding_rule,
           ael_rounding_rule,
           stm_rounding_rule
    FROM OKL_SYS_ACCT_OPTS;

Line: 786

    SELECT PRECISION
    FROM fnd_currencies_vl
    WHERE currency_code = p_currency_code
    AND enabled_flag = 'Y'
    AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 974

	SELECT chart_of_accounts_id
	FROM GL_LEDGERS_PUBLIC_V
	WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);

Line: 979

	SELECT segment_num,
               application_column_name,
               form_left_prompt
	FROM fnd_id_flex_segments_vl
    	WHERE application_id = 101
	    AND id_flex_code = 'GL#'
	    AND enabled_flag = 'Y'
	    AND id_flex_num = l_chart_of_accounts_id;

Line: 1018

	SELECT chart_of_accounts_id
	FROM GL_LEDGERS_PUBLIC_V
	WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);

Line: 1023

	SELECT form_left_prompt
     	FROM fnd_id_flex_segments_vl
     	WHERE application_id = 101
     	AND   id_flex_code = 'GL#'
     	AND   enabled_flag = 'Y'
     	AND   id_flex_num = l_chart_of_accounts_id
     	AND   application_column_name = p_segment;

Line: 1062

    SELECT meaning
    FROM fnd_lookup_values flv,
    	 fnd_lookup_types flt
    WHERE
    	flv.lookup_type = p_lookup_type
    AND flv.view_application_id = p_view_app_id
    AND flv.lookup_code = p_lookup_code
    AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
    AND flv.LANGUAGE = USERENV('LANG')
    AND flv.enabled_flag = 'Y'
    AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)
    AND flv.lookup_type = flt.lookup_type
    AND flv.view_application_id = flt.view_application_id
    AND flv.security_group_id = flt.security_group_id
    AND flt.application_id = p_app_id;

Line: 1106

    SELECT meaning
    FROM fnd_lookup_values flv,
    	 fnd_lookup_types flt
    WHERE
    	flv.lookup_type = p_lookup_type
    AND flv.view_application_id = p_view_app_id
    AND flv.lookup_code = p_lookup_code
    AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
    AND flv.LANGUAGE = p_language
    AND flv.enabled_flag = 'Y'
    AND TRUNC(NVL(flv.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(flv.end_date_active, l_sysdate)) >= TRUNC(l_sysdate)
    AND flv.lookup_type = flt.lookup_type
    AND flv.view_application_id = flt.view_application_id
    AND flv.security_group_id = flt.security_group_id
    AND flt.application_id = p_app_id;

Line: 1145

	SELECT '1'
	FROM gl_daily_conversion_types
	WHERE conversion_type = p_currency_con_type;

Line: 1177

	SELECT currency_code
    	FROM   GL_LEDGERS_PUBLIC_V
    	WHERE  ledger_id = l_ledger_id;

Line: 1205

	SELECT '1'
    	FROM   gl_je_categories
    	WHERE  je_category_name = p_category;

Line: 1239

    SELECT chart_of_accounts_id
    FROM GL_LEDGERS_PUBLIC_V
    WHERE ledger_id = l_ledger_id;

Line: 1349

	l_sql_stmt := 'SELECT ''1'' ' ||
				  'FROM ' || p_view ||
				  ' WHERE id <>  ' || p_id ||
                  l_where_clause ||
                  ' AND ( ' || format_date(l_start_date ) ||
				  ' BETWEEN ' || p_start_date_attribute_name || ' AND ' ||
				  ' NVL(' || p_end_date_attribute_name || ',' || format_date(g_final_date) || ') OR '
               	  || format_date(l_end_date) ||
				  ' BETWEEN ' || p_start_date_attribute_name || ' AND ' ||
				  ' NVL(' || p_end_date_attribute_name || ', ' || format_date(g_final_date) || ')) ' ||
				  ' UNION ALL ' ||
			   	  'SELECT ''2'' ' ||
				  'FROM ' || p_view ||
				  ' WHERE id <>  ' || p_id ||
                  l_where_clause ||
				  ' AND ' || format_date(l_start_date ) ||
				  ' <= ' || p_start_date_attribute_name ||
				  ' AND ' || format_date(l_end_date ) ||
				  ' >= NVL(' || p_end_date_attribute_name || ', ' || format_date(g_final_date) || ') ';

Line: 1475

		  l_sql_stmt := 'SELECT ''1'' ' ||
		  	  		 	'FROM ' || p_view ||
						l_where_clause ||
			  			' AND NVL(' || p_end_date_attribute_name || ', ' ||
						'''' || OKL_API.G_MISS_DATE || '''' || ') > ' ||
						'''' || p_end_date || '''';

Line: 1543

  SELECT concatenated_segments
  FROM gl_code_combinations_kfv
  WHERE code_combination_id = p_ccid;

Line: 1572

  SELECT concatenated_segments, chart_of_accounts_id
  FROM gl_code_combinations_kfv
  WHERE code_combination_id = p_code_combination_id;

Line: 1607

  SELECT meaning
  FROM fa_lookups fal
  WHERE fal.lookup_type = p_lookup_type
  AND fal.lookup_code = p_lookup_code
  AND fal.enabled_flag = 'Y'
  AND TRUNC(NVL(fal.start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
  AND TRUNC(NVL(fal.end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 1650

  SELECT fc.precision, fc.extended_precision, fc.minimum_accountable_unit
  FROM fnd_currencies fc
  WHERE fc.currency_code = p_currency_code;

Line: 1752

    SELECT PRECISION
    INTO l_precision
    FROM fnd_currencies fc
    WHERE fc.currency_code = p_currency_code;

Line: 1772

      SELECT meaning
      FROM OKC_RULE_DEFS_V rdef
      WHERE rdef.rule_code = c_rule_code;

Line: 1777

 SELECT meaning
    FROM fnd_lookup_types flt,
      fnd_lookup_values flv
    WHERE  flv.lookup_type = flt.lookup_type
    AND flv.security_group_id = flt.security_group_id
    AND flv.view_application_id = flt.view_application_id
    AND flv.LANGUAGE = USERENV('LANG')
    AND flv.security_group_id = fnd_global.lookup_security_group(flv.lookup_type, flv.view_application_id)
    AND flt.lookup_type = 'OKC_RULE_DEF'
    AND flv.lookup_code = c_rule_code
    AND flt.application_id = 510
    AND flv.view_application_id = 0
    AND ENABLED_FLAG = 'Y'
	AND NVL(start_date_active, G_SYSDATE) <= G_SYSDATE
	AND NVL(end_date_active, G_SYSDATE) >= G_SYSDATE;*/

Line: 1859

SELECT  rit.attribute_label_long
FROM    ak_region_items ri, ak_region_items_tl rit
WHERE 	ri.region_code = p_region_code AND
	ri.attribute_code = p_attribute_code AND
	ri.region_application_id = p_application_id AND
	ri.attribute_application_id = p_application_id AND
	rit.language = USERENV('LANG')AND
	ri.region_code = rit.region_code AND
 	ri.attribute_code = rit.attribute_code AND
	ri.region_application_id = rit.region_application_id AND
	ri.attribute_application_id = rit.attribute_application_id ;

Line: 1918

	SELECT cc_rounding_rule INTO l_rounding_rule
	FROM OKL_SYS_ACCT_OPTS;

Line: 1921

	SELECT PRECISION INTO l_precision
	FROM fnd_currencies_vl
	WHERE currency_code = p_currency_code
	AND enabled_flag = 'Y'
	AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
	AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 1979

    SELECT cc_rounding_rule
    FROM OKL_SYS_ACCT_OPTS;

Line: 1983

    SELECT PRECISION
    FROM fnd_currencies_vl
    WHERE currency_code = p_currency_code
    AND enabled_flag = 'Y'
    AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
    AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line: 2097

  SELECT CURRENCY_CODE,
		 CURRENCY_CONVERSION_TYPE,
		 CURRENCY_CONVERSION_RATE,
		 CURRENCY_CONVERSION_DATE
  FROM	 OKL_K_HEADERS_FULL_V
  WHERE	 ID = p_khr_id;

Line: 2208

  SELECT CURRENCY_CODE,
	 CURRENCY_CONVERSION_TYPE,
	 CURRENCY_CONVERSION_RATE,
	 CURRENCY_CONVERSION_DATE
  FROM	 OKL_K_HEADERS_FULL_V
  WHERE	 ID = p_khr_id;

Line: 2362

  SELECT CURRENCY_CODE,
		 CURRENCY_CONVERSION_TYPE,
		 CURRENCY_CONVERSION_RATE,
		 CURRENCY_CONVERSION_DATE
  FROM	 OKL_K_HEADERS_FULL_V
  WHERE	 ID = p_khr_id;

Line: 2482

  SELECT CURRENCY_CODE,
		 CURRENCY_CONVERSION_TYPE,
		 CURRENCY_CONVERSION_RATE,
		 CURRENCY_CONVERSION_DATE
  FROM	 OKL_K_HEADERS_FULL_V
  WHERE	 ID = p_khr_id;

Line: 2744

SELECT MAX(end_date)
FROM gl_period_statuses
WHERE application_id = 540
AND ledger_id = l_ledger_id
AND closing_status IN ('F','O')
AND TRUNC(end_date) <= TRUNC(p_gl_date)
AND adjustment_period_flag = 'N' ;

Line: 2754

SELECT MIN(start_date)
FROM gl_period_statuses
WHERE application_id = 540
AND ledger_id = l_ledger_id
AND closing_status IN ('F','O')
AND TRUNC(start_date) >= TRUNC(p_gl_date)
AND adjustment_period_flag = 'N' ;

Line: 2831

SELECT bk.cost
FROM fa_books bk
WHERE bk.book_type_code = p_book_type_code
AND bk.asset_id = p_asset_id
AND bk.transaction_header_id_in =   p_transaction_header_id;

Line: 2840

SELECT bk.cost
FROM fa_books bk
WHERE bk.book_type_code = p_book_type_code
AND bk.asset_id = p_asset_id
AND bk.transaction_header_id_out =   p_transaction_header_id;

Line: 2891

SELECT
  DIST.POST_TO_GL
FROM
  OKL_TXL_CNTRCT_LNS LN,
  OKL_TRNS_ACC_DSTRS DIST
WHERE
  LN.TCN_ID = p_trx_id
  AND LN.ID = DIST.SOURCE_ID
  AND DIST.SOURCE_TABLE = p_source_table
  AND DIST.POST_TO_GL = 'Y';

Line: 2905

SELECT
  DIST.POST_TO_GL
FROM
  OKL_TXL_ASSETS_B LN,
  OKL_TRNS_ACC_DSTRS DIST
WHERE
      LN.TAS_ID = p_trx_id
  AND LN.DNZ_KHR_ID =p_khr_id
  AND LN.ID = DIST.SOURCE_ID
  AND DIST.SOURCE_TABLE = p_source_table
  AND DIST.POST_TO_GL = 'Y';

Line: 2978

SELECT  GREATEST(calendar_period_open_date,
        LEAST(l_sysdate, calendar_period_close_date))
FROM    fa_deprn_periods
WHERE   book_type_code = p_book_type_code
AND     period_close_date IS NULL;

Line: 3048

SELECT
  TXL.FA_TRX_DATE
FROM
  OKL_TXL_ASSETS_B txl,
  OKL_TRX_ASSETS TRX,
  OKL_TRX_TYPES_V TRY
WHERE
  TXL.ASSET_NUMBER = p_asset_number AND
  TXL.CORPORATE_BOOK = p_corporate_book AND
  TXL.DNZ_KHR_ID = p_khr_id  AND
  TXL.TAS_ID = TRX.ID AND
  TRX.TRY_ID = TRY.ID AND
  TRY.NAME IN ('Internal Asset Creation', 'Release');

Line: 3097

SELECT
  MAX(TXL.FA_TRX_DATE)
FROM
  OKL_TXL_ASSETS_B txl,
  OKL_TRX_ASSETS TRX,
  OKL_TRX_TYPES_V TRY
WHERE
  TXL.ASSET_NUMBER = p_asset_number AND
  TXL.CORPORATE_BOOK = p_corporate_book AND
  TXL.DNZ_KHR_ID = p_khr_id  AND
  TXL.TAS_ID = TRX.ID AND
  TRX.TRY_ID = TRY.ID AND
  TRY.NAME IN ('Off Lease Amortization', 'Asset Disposition');

Line: 3135

    SELECT short_name
    FROM gl_ledgers
    WHERE ledger_id = l_ledger_id;

Line: 3169

    SELECT account_derivation
    FROM okl_sys_acct_opts;

Line: 3190

         SELECT RPT_PROD_BOOK_TYPE_CODE
         FROM   OKL_SYSTEM_PARAMS_ALL
         WHERE  ORG_ID = l_org_id;

Line: 3211

         SELECT a.authoring_org_id ORG_ID
         FROM   okc_k_headers_all_b a,
                okc_k_lines_b b
         WHERE  b.id = p_kle_id
         AND    b.dnz_chr_id = a.id;

Line: 3245

  SELECT a.start_date, a.contract_number, b.pdt_id
  FROM   okc_k_headers_b a, okl_k_headers b
  WHERE  a.id = b.id
  AND    a.id = cp_khr_id;