APPS.OKL_PAYMENT_SPLIT_PVT SQL Statements

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

Line: 81

   SELECT SUM(NVL(okl1.capital_amount,0))
   FROM   okl_k_lines_full_v okl1, -- fee sub line
          okl_k_lines_full_v okl2, -- fee top line
          okc_k_items_v item1,
          okc_k_items_v item2,
          okl_strmtyp_source_v stream
   WHERE  item1.object1_id1       = TO_CHAR(p_fin_line_id) -- Bug 3830454
   AND    item1.jtot_object1_code = 'OKX_COVASST'       -- Bug 3830454
   AND    stream.capitalize_yn = 'Y'
   AND    okl1.id              = item1.cle_id
   AND    okl2.id              = okl1.cle_id
   AND    okl2.id              = item2.cle_id
   AND    item2.object1_id1    = stream.id1;

Line: 133

   SELECT currency_code
   FROM   okc_k_headers_v
   WHERE  id = p_chr_id;

Line: 138

   SELECT precision
   FROM   fnd_currencies
   WHERE  currency_code = p_curr_code;

Line: 212

   SELECT ID1
   FROM   okl_strmtyp_source_v
   WHERE  code = p_strm_code;

Line: 355

   SELECT SUM(NVL(line.capital_amount,0))
   FROM   okl_k_lines_full_v line
   WHERE  line.dnz_chr_id = p_chr_id
   AND    EXISTS ( SELECT 'Y'
                   FROM   okc_line_styles_v style
                   WHERE  line.lse_id    = style.id
                   AND    style.lty_code = 'FREE_FORM1'
                  )
   -- added to handle abandon line
   AND    NOT EXISTS (
                      SELECT 'Y'
		      FROM   okc_statuses_v okcsts
		      WHERE  okcsts.code = line.sts_code
		      AND    okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line: 372

   SELECT SUM(NVL(line.capital_amount,0))
   FROM   okl_k_lines_full_v line,
          okc_line_styles_v  style,
          okc_k_items_v      item,
          okl_strmtyp_source_v stream
   WHERE  style.lty_code       = 'FEE'
   AND    line.dnz_chr_id      = p_chr_id
   AND    stream.capitalize_yn = 'Y'
   AND    line.lse_id          = style.id
   AND    line.id              = item.cle_id
   AND    item.object1_id1     = stream.id1
   -- added to handle abandon line
   AND    NOT EXISTS (
                      SELECT 'Y'
		      FROM   okc_statuses_v okcsts
		      WHERE  okcsts.code = line.sts_code
		      AND    okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line: 478

  SELECT okl.*
  FROM   okl_k_lines_full_v okl,
         okc_line_styles_b ols
  WHERE  okl.dnz_chr_id = p_chr_id
  AND    okl.lse_id     = ols.id
  AND    ols.lty_code   = 'FREE_FORM1'
  -- added to handle abandon line
  AND    NOT EXISTS (
                     SELECT 'Y'
	             FROM   okc_statuses_b okcsts
	             WHERE  okcsts.code = okl.sts_code
	             AND    okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line: 492

  SELECT 'Y'
  FROM   okl_strmtyp_source_v
  WHERE  code = p_strm_code;

Line: 497

  SELECT 'Y'
  FROM   okl_time_units_v
  WHERE  id1 = p_freq_code;