APPS.OKC_CURRENCY_API SQL Statements

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

Line: 30

  select gl.currency_code
  into   l_curr_code
  from   okx_set_of_books_v gl,
	    okx_organization_defs_v ou
  where  ou.id1 = l_org_id
  and    ou.organization_type = 'OPERATING_UNIT'
  and    ou.information_type = 'Operating Unit Information'
  and    gl.set_of_books_id = ou.set_of_books_id ;

Line: 40

  select gl.currency_code
  into   l_curr_code
  from   HR_ORGANIZATION_INFORMATION OI2,
         HR_ORGANIZATION_INFORMATION OI1,
	    HR_ALL_ORGANIZATION_UNITS OU,
	    GL_SETS_OF_BOOKS gl
  where oi1.organization_id = ou.organization_id
  and   oi2.organization_id = ou.organization_id
  and   oi1.org_information_context = 'CLASS'
  and   oi1.org_information1 = 'OPERATING_UNIT'
  and   oi2.org_information_context =  'Operating Unit Information'
  and   oi2.ORG_INFORMATION3 = gl.set_of_books_id
  and   ou.organization_id = l_org_id;

Line: 76

  select currency_code
  into   l_curr_code
  from   okx_set_of_books_v
  where  set_of_books_id = p_sob_id;

Line: 113

  select ou.set_of_books_id
  into   l_sob_id
  from   okx_organization_defs_v ou where  ou.id1 = l_org_id and    ou.organization_type = 'OPERATING_UNIT'
  and    ou.information_type = 'Operating Unit Information';

Line: 119

  select oi2.ORG_INFORMATION3
  into   l_sob_id
  from   HR_ORGANIZATION_INFORMATION OI2,
         HR_ORGANIZATION_INFORMATION OI1,
	    HR_ALL_ORGANIZATION_UNITS OU
  where oi1.organization_id = ou.organization_id
  and   oi2.organization_id = ou.organization_id
  and   oi1.org_information_context = 'CLASS'
  and   oi1.org_information1 = 'OPERATING_UNIT'
  and   oi2.org_information_context =  'Operating Unit Information'
  and   ou.organization_id = l_org_id;

Line: 163

  select gl.name
  into   l_sob_name
  from   okx_organization_defs_v ou,
	    okx_set_of_books_v gl
  where  ou.id1 = l_org_id
  and    ou.organization_type = 'OPERATING_UNIT'
  and    ou.information_type = 'Operating Unit Information'
  and    gl.set_of_books_id = ou.set_of_books_id;

Line: 173

  select gl.name
  into   l_sob_name
  from   HR_ORGANIZATION_INFORMATION OI2,
         HR_ORGANIZATION_INFORMATION OI1,
	    HR_ALL_ORGANIZATION_UNITS OU,
	    GL_SETS_OF_BOOKS gl
  where oi1.organization_id = ou.organization_id
  and   oi2.organization_id = ou.organization_id
  and   oi1.org_information_context = 'CLASS'
  and   oi1.org_information1 = 'OPERATING_UNIT'
  and   oi2.org_information_context =  'Operating Unit Information'
  and   oi2.ORG_INFORMATION3 = gl.set_of_books_id
  and   ou.organization_id = l_org_id;

Line: 417

   SELECT decode( derive_type,
    		'EURO', 'EURO',
     		'EMU', decode( sign( trunc(p_eff_date) - trunc(derive_effective)),
			                -1, 'OTHER', 'EMU'),
		      'OTHER' ),
		 decode( derive_type,
		        'EURO', 1,
		        'EMU', derive_factor,
			'OTHER', -1 ),
	     nvl( minimum_accountable_unit, power( 10, (-1 * precision)))
   INTO   x_currency_type, x_conversion_rate, x_mau
   FROM   FND_CURRENCIES
   WHERE  currency_code = p_currency;

Line: 454

   SELECT decode( derive_type,
    		'EURO', 'EURO',
     		'EMU', decode( sign( trunc(p_eff_date) - trunc(derive_effective)),
			                -1, 'OTHER', 'EMU'),
		      'OTHER' )
   INTO   l_currency_type
   FROM   FND_CURRENCIES
   WHERE  currency_code = p_currency;