APPS.APRX_PY SQL Statements

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

Line: 70

		'aprx_py.register_bind(:CURSOR_SELECT);',

Line: 320

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

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

Line: 341

   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
    and sys.org_id = param.org_id;

Line: 413

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

Line: 415

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