APPS.GMS_INSTALL SQL Statements

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

Line: 34

     select 1 into l_dummy
     from dual where exists
        (select 1
         from gms_implementations
         where enabled = 'Y');

Line: 42

     select 1 into l_dummy
     from dual where exists
        (select 1
         from gms_implementations
         where org_id = x_org_id
         and   enabled = 'Y');

Line: 66

  select org_id
  BULK COLLECT into t_org_id
  from  gms_implementations;

Line: 119

   select 'Y'
   into   g_sponsored_flag
   from   pa_projects_all pp,
          pa_project_types_all pt
   where  pp.project_id = p_project_id
   and    pp.project_type = pt.project_type
   and    pp.org_id = pt.org_id
   and    nvl(pt.sponsored_flag,'N') = 'Y';

Line: 147

    		--select 'X'
	  	--into x_temp
	  	select 'X' into x_temp from dual where exists (
	  	select 1
	  	from gms_implementations_all );