APPS.APRX_PY SQL Statements

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

Line: 64

		'aprx_py.register_bind(:CURSOR_SELECT);',

Line: 278

  SELECT sob.name, sob.currency_code
  INTO aprx_py.var.ORGANIZATION_NAME, aprx_py.var.FUNCTIONAL_CURRENCY_CODE
  FROM ap_system_parameters sys, gl_sets_of_books sob
  WHERE sys.set_of_books_id = sob.set_of_books_id;

Line: 332

  select substrb(meaning,1,10) into l_nls_yes from fnd_lookups
	where lookup_type='YES_NO' and lookup_code='Y';

Line: 334

  select substrb(meaning,1,10) into l_nls_no from fnd_lookups
	where lookup_type='YES_NO' and lookup_code='N';