APPS.JG_GLPPOS_PKG SQL Statements

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

Line: 24

  /* select global_attribute_category
  into   v_global_attribute_category
  from   gl_sets_of_books
  where  set_of_books_id = v_set_of_books_id;

Line: 29

select 'Y'
into v_install_flag
from dual
where exists
(select 'Y'                          --
   from fnd_product_installations    -- Check if European Localization(7002)
  where application_id = 7002        -- is installed.
   and  db_status = 'I'              --
   and  status = 'I'                 --
 intersect
 select 'Y'                          --
 from fnd_product_installations      -- Check if Regional Localization(7003)
 where application_id = 7003         -- is installed.
   and db_status = 'I'               --
   and status = 'I' );                 --