APPS.OKL_SEC_CONCURRENT_PVT SQL Statements

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

Line: 92

  SELECT okls.set_of_books_id set_of_books_id
        ,glsb.name            set_of_books_name
  FROM   GL_LEDGERS_PUBLIC_V  glsb
        ,OKL_SYS_ACCT_OPTS okls
  WHERE  glsb.ledger_id =  okls.set_of_books_id;

Line: 101

  SELECT name
  FROM   hr_operating_units
  WHERE  organization_id = mo_global.get_current_org_id();

Line: 108

  SELECT chrb.contract_number agreement_number
        ,polb.pool_number pool_number
	,polb.currency_code currency_code
  FROM  okl_pools polb
       ,okc_k_headers_b chrb
  WHERE polb.khr_id = chrb.id
  AND   polb.khr_id = p_khr_id;

Line: 120

  SELECT pocb.id id
        ,chrb.contract_number contract_number
		,clet.name asset_number
		,styv.name stream_type_name
  FROM   okl_pool_contents pocb
        ,okl_pools polb
		,okc_k_headers_b chrb
		,okc_k_lines_tl clet
		,okl_strm_type_v styv
  WHERE  pocb.pol_id = polb.id
  AND    polb.khr_id = p_khr_id
  AND    pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
  AND    pocb.streams_to_date > p_effective_date
  AND    pocb.khr_id = chrb.id
  AND    pocb.kle_id = clet.id
  AND    pocb.sty_id = styv.id;

Line: 139

  SELECT okxv.name
        ,chrb.currency_code
  FROM   OKX_PARTIES_V okxv
        ,okc_k_headers_all_b chrb
        ,okc_k_lines_b cleb
        ,okc_k_party_roles_b cplb
  WHERE  cleb.id = p_id
  AND    cleb.dnz_chr_id = chrb.id
  AND    cplb.cle_id = cleb.id
  AND    cplb.dnz_chr_id = cleb.dnz_chr_id
  AND    okxv.id1 = cplb.object1_id1
  AND    okxv.id2 = cplb.object1_id2;

Line: 155

  SELECT DISTINCT
         pocb.khr_id dnz_chr_id
  FROM   okl_pool_contents pocb
        ,okl_pools polb
  WHERE  pocb.pol_id = polb.id
  AND    polb.khr_id = p_khr_id
  AND    pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE;

Line: 166

  SELECT DISTINCT
         pocb.pol_id
        ,pocb.khr_id
		,styb.stream_type_subclass
  FROM   okl_pool_contents pocb
        ,okl_pools polb
        ,okl_strm_type_b styb
  WHERE  pocb.pol_id = polb.id
  AND    polb.khr_id = p_khr_id
  AND    pocb.sty_id = styb.id
  AND    pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
  ORDER BY pocb.khr_id,styb.stream_type_subclass;

Line: 183

  SELECT pol_id
        ,khr_id
		,contract_number
		,sty_subclass_code
		,sty_subclass
        ,streams_amount
		,currency_code
  FROM   okl_sec_buyback_streams_uv
  WHERE  pol_id = p_pol_id;

Line: 679

  SELECT chrb.sts_code
  FROM OKC_K_HEADERS_ALL_B CHRB
  WHERE CHRB.ID = p_chr_id;