APPS.PO_CORE_S3 SQL Statements

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

Line: 29

  SELECT        nvl(multi_org_flag, 'N')
  INTO          l_multi_org
  FROM          fnd_product_groups;

Line: 58

      /* SELECT substr(hou.name,1,20) */
      /* Bug 943602: Display 30 chars to be consistent with client side code */
      /*SELECT substr(hou.name,1,64)*/
      /* Bug 1040332, zxzhang, substr is dependent on character set */
      /*SELECT substr(hou.name,1,30)*/
      SELECT substrb(hou.name,1,30)
      INTO   x_org_sob_name
      FROM   hr_organization_units hou
      WHERE  hou.organization_id = x_org_sob_id;

Line: 85

    SELECT org_id
    INTO   x_org_sob_id
    FROM   po_system_parameters;

Line: 113

      /* SELECT substr(hou.name,1,20) */
      /* Bug 943602: Display 30 chars to be consistent with client side code */
      /*SELECT substr(hou.name,1,64)*/
      /* Bug 1040332, zxzhang, substr is dependent on character set */
      /*SELECT substr(hou.name,1,30)*/
      SELECT substrb(hou.name,1,30)
      INTO   x_org_sob_name
      FROM   hr_organization_units hou
      WHERE  hou.organization_id = x_org_sob_id;

Line: 127

      SELECT fsp.set_of_books_id,
	     gsb.short_name
      INTO   x_org_sob_id,
	     x_org_sob_name
      FROM   financials_system_parameters fsp,
	     gl_sets_of_books gsb
      WHERE  fsp.set_of_books_id = gsb.set_of_books_id;