APPS.OKL_POOLCONC_PVT SQL Statements

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

Line: 106

  SELECT status_code
  FROM   okl_pools
  WHERE  id = p_pol_id;

Line: 112

  SELECT polv.pool_number               pool_number
        ,psts.meaning                   pool_status
  FROM   OKL_POOLS polv -- to take care of org_id
        ,okc_statuses_tl psts
  WHERE  polv.id = p_pol_id
  AND    polv.status_code = psts.code
  AND    psts.LANGUAGE = USERENV('LANG');

Line: 122

  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: 130

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

Line: 136

  SELECT name
  FROM   OKX_PARTIES_V
  WHERE  id1 = p_cust_object1_id1;

Line: 142

  SELECT name
  FROM   OKL_POOL_CUST_INDUSTRY_UV
  WHERE  code = p_sic_code;

Line: 148

  SELECT contract_number
  FROM   OKC_K_HEADERS_V
  WHERE  id = p_dnz_chr_id;

Line: 154

  SELECT meaning
  FROM   FND_LOOKUPS
  WHERE lookup_type='OKL_BOOK_CLASS'
  AND NVL(start_date_active,SYSDATE) <=SYSDATE
  AND NVL(end_date_active,SYSDATE+1) > SYSDATE
  AND enabled_flag = 'Y'
  AND lookup_code = p_book_classification;

Line: 164

  SELECT meaning
  FROM   FND_LOOKUPS
  WHERE lookup_type='OKL_TAX_OWNER'
  AND NVL(start_date_active,SYSDATE) <=SYSDATE
  AND NVL(end_date_active,SYSDATE+1) > SYSDATE
  AND enabled_flag = 'Y'
  AND lookup_code = p_tax_owner;

Line: 174

  SELECT name
  FROM   OKL_PRODUCTS
  WHERE  id = p_pdt_id;

Line: 180

  SELECT meaning
  FROM   fnd_lookups
  WHERE  lookup_type = 'OKL_STREAM_TYPE_SUBCLASS'
  AND    lookup_code = p_stream_type_subclass;

Line: 188

   SELECT MEANING AS CREDITCXLSSFCTN
   FROM   AR_LOOKUPS fndlup
   WHERE  LOOKUP_TYPE = 'AR_CMGT_CREDIT_CLASSIFICATION'
   AND LOOKUP_CODE = p_cust_crd_clf_code
   AND ENABLED_FLAG = 'Y'
   AND    SYSDATE BETWEEN NVL   (fndlup.start_date_active,sysdate)
                  AND     NVL(fndlup.end_date_active,sysdate);

Line: 201

  SELECT lookup_code,
	     meaning
  FROM   fnd_lookups
  WHERE LOOKUP_TYPE LIKE 'OKL_POOL_REJECT_REASON'
  ORDER BY LOOKUP_CODE;

Line: 815

  SELECT pol.id
FROM okl_pools pol
WHERE EXISTS
       (SELECT '1'
        FROM   okl_pool_contents poc
        WHERE  poc.pol_id = pol.id
        AND    poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE))
;

Line: 825

  SELECT pol.id
FROM okl_pools pol
WHERE pol.pool_number = p_pool_number
;

Line: 1097

  SELECT polb.id
  FROM   okl_pools polb
  WHERE EXISTS
        (SELECT '1'
         FROM   okl_pool_contents pocb
         WHERE  pocb.pol_id = polb.id
         AND    pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
         -- Bug#2829983
         AND    polb.status_code = 'NEW'
        );

Line: 1112

  SELECT polb.id
  FROM   okl_pools polb
  WHERE  polb.pool_number = p_pool_number
         -- Bug#2829983
  AND    polb.status_code = 'NEW';

Line: 1302

  SELECT polb.id
  FROM   okl_pools polb
  WHERE EXISTS
        (SELECT '1'
         FROM   okl_pool_contents pocb
         WHERE  pocb.pol_id = polb.id
         AND    pocb.status_code = G_POC_STS_PENDING
         AND    polb.status_code = 'ACTIVE'
        );

Line: 1316

  SELECT polb.id
  FROM   okl_pools polb
  WHERE  polb.pool_number = p_pool_number
  AND    polb.status_code = 'ACTIVE';

Line: 1638

  SELECT status_code
  FROM   okl_pools
  WHERE  id = p_pol_id;

Line: 1643

  SELECT polv.pool_number               pool_number
        ,psts.meaning                   pool_status
        ,polv.date_created              date_created
		,polv.date_last_updated         date_last_updated
		,polv.date_last_reconciled      date_last_reconciled
		,polv.total_principal_amount    total_net_asset_net_investment
		,polv.date_total_principal_calc date_last_calculated
  FROM   OKL_POOLS polv -- to take care of org_id
        ,okc_statuses_tl psts
  WHERE  polv.id = p_pol_id
  AND    polv.status_code = psts.code
  AND    psts.LANGUAGE = USERENV('LANG');

Line: 1658

  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: 1666

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

Line: 1672

  SELECT name
  FROM   OKX_PARTIES_V
  WHERE  id1 = p_cust_object1_id1;

Line: 1678

  SELECT name
  FROM   OKL_POOL_CUST_INDUSTRY_UV
  WHERE  code = p_sic_code;

Line: 1684

  SELECT contract_number
  FROM   OKC_K_HEADERS_V
  WHERE  id = p_dnz_chr_id;

Line: 1690

  SELECT meaning
  FROM   FND_LOOKUPS
  WHERE lookup_type='OKL_BOOK_CLASS'
  AND NVL(start_date_active,SYSDATE) <=SYSDATE
  AND NVL(end_date_active,SYSDATE+1) > SYSDATE
  AND enabled_flag = 'Y'
  AND lookup_code = p_book_classification;

Line: 1700

  SELECT meaning
  FROM   FND_LOOKUPS
  WHERE lookup_type='OKL_TAX_OWNER'
  AND NVL(start_date_active,SYSDATE) <=SYSDATE
  AND NVL(end_date_active,SYSDATE+1) > SYSDATE
  AND enabled_flag = 'Y'
  AND lookup_code = p_tax_owner;

Line: 1710

  SELECT name
  FROM   OKL_PRODUCTS
  WHERE  id = p_pdt_id;

Line: 1716

  SELECT asset_number
  FROM   OKL_POOL_ASSETS_LOV_UV
  WHERE  asset_id = p_asset_id;

Line: 1722

  SELECT name
  FROM  OKX_SYSTEM_ITEMS_V
  WHERE ID2 = OKL_SYSTEM_PARAMS_ALL_PUB.get_system_param_value(OKL_SYSTEM_PARAMS_ALL_PUB.G_ITEM_INV_ORG_ID)
  AND   id1 = p_item_id1;

Line: 1729

  SELECT name
  FROM OKX_VENDORS_V
  WHERE id1 = p_vendor_id1;

Line: 1736

  SELECT name
  FROM   okl_strm_type_v
  WHERE id = p_sty_id;

Line: 1743

  SELECT meaning
  FROM   fnd_lookups
  WHERE  lookup_type = 'OKL_STREAM_TYPE_SUBCLASS'
  AND    lookup_code = p_stream_type_subclass;

Line: 1751

   SELECT MEANING AS CREDITCXLSSFCTN
   FROM   AR_LOOKUPS fndlup
   WHERE  LOOKUP_TYPE = 'AR_CMGT_CREDIT_CLASSIFICATION'
   AND LOOKUP_CODE = p_cust_crd_clf_code
   AND ENABLED_FLAG = 'Y'
   AND    SYSDATE BETWEEN NVL   (fndlup.start_date_active,sysdate)
                  AND     NVL(fndlup.end_date_active,sysdate);

Line: 1945

          FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,G_LAST_UPDATE_DATE),l_prompt_len) || ' : ' || l_okl_pol_rec.date_last_updated);