APPS.OKL_ST_CODE_CONVERSIONS SQL Statements

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

Line: 97

        select TERRITORY_SHORT_NAME
        into x_country
        from fnd_territories_vl
        where territory_code = p_country;

Line: 215

	SELECT VALUE
	FROM   OKL_SGN_TRANSLATIONS
	WHERE  JTOT_OBJECT1_CODE = 'FA_METHODS'
	AND object1_id1 = p_id;

Line: 288

	SELECT VALUE
	FROM   OKL_SGN_TRANSLATIONS
	WHERE  JTOT_OBJECT1_CODE = 'FA_CONVENTION_TYPES'
	AND object1_id1 = p_id;

Line: 885

        SELECT
              sfe.deal_type,sil.sil_type
        FROM   okl_stream_interfaces_v sfe,
               okl_sif_lines_v sil
        WHERE  transaction_number = cp_transaction_no
        AND    sil.sif_id = sfe.id;

Line: 920

	 SELECT
	  AMOUNT
	FROM
	  OKL_SIF_FEES SFEB,
	  OKL_STREAM_INTERFACES SIFB
	WHERE
	  SFEB.SIF_ID = SIFB.ID AND
          SFEB.SFE_TYPE = 'SFR' AND
          SFEB.FEE_INDEX_NUMBER = cp_fee_index AND
          SIFB.transaction_number = cp_transaction_no;

Line: 948

SELECT FEES.BALANCE_TYPE_CODE
FROM OKL_SIF_FEES_V FEES,
     OKL_STREAM_INTERFACES SIF
WHERE SIF.TRANSACTION_NUMBER = p_trx_number
AND   SIF.ID = FEES.SIF_ID
AND   FEES.BALANCE_TYPE_CODE IS NOT NULL;

Line: 1009

      SELECT fee_purpose_code
      FROM OKL_K_LINES
      WHERE ID = p_fee_line_id;

Line: 1053

   SELECT KHR_ID
   FROM OKL_STREAM_INTERFACES
   WHERE TRANSACTION_NUMBER = p_trx_number;

Line: 1060

   SELECT count(crl.id)
   FROM okc_rule_groups_b crg,
        okc_rules_b crl,
        okl_strm_type_v sty
   WHERE crl.rgp_id = crg.id
   AND crg.rgd_code = 'LALEVL'
   AND crl.rule_information_category = 'LASLH'
   AND crg.dnz_chr_id = chrId
   AND crl.object1_id1 = sty.id
   AND sty.stream_type_purpose = 'UNSCHEDULED_PRINCIPAL_PAYMENT'
   ORDER BY crl.rule_information1;