APPS.OKE_FUNDING_UTIL_PKG SQL Statements

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

Line: 28

   select amount, available_amount
   from   oke_pool_parties
   where  pool_party_id = x_pool_party_id;

Line: 33

   select amount
   from   oke_k_funding_sources
   where  funding_source_id = x_source_id;

Line: 120

  	select nvl(start_date_active, x_date)
  	from   oke_pool_parties
  	where  pool_party_id = x_pool_party_id;

Line: 125

  	select nvl(end_date_active, x_date)
  	from   oke_pool_parties
  	where  pool_party_id = x_pool_party_id;

Line: 210

     select nvl(sum(amount), 0)
     from   oke_k_fund_allocations
     where  funding_source_id = x_source_id;

Line: 215

      select amount
      from   oke_k_funding_sources
      where  funding_source_id = x_source_id;

Line: 220

      select amount
      from   oke_k_fund_allocations
      where  fund_allocation_id = x_allocation_id;

Line: 320

     select nvl(sum(hard_limit), 0), nvl(sum(revenue_hard_limit), 0)
     from   oke_k_fund_allocations
     where  funding_source_id = x_source_id;

Line: 325

      select nvl(hard_limit, 0), nvl(revenue_hard_limit, 0)
      from   oke_k_funding_sources
      where  funding_source_id = x_source_id;

Line: 330

      select nvl(hard_limit, 0), nvl(revenue_hard_limit, 0)
      from   oke_k_fund_allocations
      where  fund_allocation_id = x_allocation_id;

Line: 448

     select 'x'
     from   oke_k_funding_sources
     where  pool_party_id = x_pool_party_id;

Line: 453

     select nvl(min(start_date_active), add_months(x_date, -1))
     from   oke_k_funding_sources
     where  pool_party_id = x_pool_party_id;

Line: 458

     select nvl(max(end_date_active), add_months(x_date, 1))
     from   oke_k_funding_sources
     where  pool_party_id = x_pool_party_id;

Line: 537

   select count(1)
   into   l_count
   from   oke_k_funding_sources
   where  pool_party_id = x_pool_party_id;

Line: 583

   	  select amount, available_amount
   	  from   oke_pool_parties
   	  where  pool_party_id = x_pool_party_id;

Line: 643

   	 select min(nvl(start_date_active, add_months(x_date, -1)))
         from   oke_k_fund_allocations
         where  funding_source_id = x_funding_source_id;

Line: 648

    	select max(nvl(end_date_active, add_months(x_date, 1)))
        from   oke_k_fund_allocations
        where  funding_source_id = x_funding_source_id;

Line: 653

  	select start_date_active
  	from oke_k_fund_allocations
  	where funding_source_id = x_funding_source_id;

Line: 658

  	select end_date_active
  	from oke_k_fund_allocations
  	where funding_source_id = x_funding_source_id;

Line: 756

   	select nvl(start_date_active, x_date)
   	from   oke_k_funding_sources
   	where  funding_source_id = x_funding_source_id;

Line: 761

   	select nvl(end_date_active, x_date)
   	from   oke_k_funding_sources
   	where  funding_source_id = x_funding_source_id;

Line: 842

      select count(p.project_id),
      	     p.segment1
      from   pa_project_customers c,
      	     pa_projects_all p
      where  p.project_id = x_project_id
      and    p.project_id = c.project_id
      and    c.customer_bill_split <> 0
      group by p.project_id, p.segment1;

Line: 945

      select nvl(sum(amount), 0)
      from   oke_k_fund_allocations
      where  funding_source_id = x_source_id;

Line: 1035

      select nvl(sum(hard_limit), 0), nvl(sum(revenue_hard_limit), 0)
      from   oke_k_fund_allocations
      where  funding_source_id = x_source_id;

Line: 1159

      select nvl(agreement_flag, 'N')
      from   oke_k_funding_sources
      where  funding_source_id = x_funding_source_id;

Line: 1190

      select currency_code
      from   pa_projects_all p,
      	     pa_implementations_all i,
      	     gl_sets_of_books g
      where  p.project_id = x_project_id
      and    nvl(p.org_id, -99) = nvl(i.org_id, -99)
      and    i.set_of_books_id = g.set_of_books_id;

Line: 1228

      select employee_id
      from   fnd_user
      where  user_id = x_user_id;

Line: 1272

     SELECT agreement_type, customer_id
     FROM   pa_agreements_all
     WHERE  pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE
     AND    pm_agreement_reference LIKE '%-' || to_char(x_funding_source_id);

Line: 1305

PROCEDURE update_alloc_version(x_fund_allocation_id			IN	NUMBER,
			       x_version_add				IN	NUMBER,
  			       x_commit					IN	VARCHAR2 := OKE_API.G_FALSE
		              ) is

begin

   update oke_k_fund_allocations
   set    agreement_version = nvl(agreement_version, 0) + x_version_add,
          insert_update_flag = null
   where  fund_allocation_id = x_fund_allocation_id;

Line: 1323

end update_alloc_version;

Line: 1337

PROCEDURE update_source_flag(x_funding_source_id		IN	NUMBER,
  			     x_commit				IN	VARCHAR2 := OKE_API.G_FALSE
		            ) is
  l_flag VARCHAR2(1) := 'N';

Line: 1342

    SELECT 'Y'
     FROM   pa_agreements_all
     WHERE  pm_product_code = OKE_FUNDING_PUB.G_PRODUCT_CODE
     AND    pm_agreement_reference LIKE '%-' || to_char(x_funding_source_id);

Line: 1352

   UPDATE oke_k_funding_sources
   SET    agreement_flag = l_flag
   WHERE  funding_source_id = x_funding_source_id;

Line: 1362

END update_source_flag;

Line: 1533

    	select currency_code
    	from   oke_k_funding_sources
    	where  funding_source_id = x_funding_source_id;

Line: 1538

    	select nvl(minimum_accountable_unit, power(10, -1 * precision)),
    	       p.projfunc_currency_code
    	from   pa_projects_all p,
    	       fnd_currencies f
    	where  project_id = x_project_id
    	and    f.currency_code = p.projfunc_currency_code;