APPS.PA_PAXEXCPS_XMLP_PKG SQL Statements

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

Line: 48

select nvl(paimp.org_id,-99) into org_id1  from pa_implementations paimp;

Line: 60

   select meaning into ndf from pa_lookups where
    lookup_code = 'NO_DATA_FOUND' and
    lookup_type = 'MESSAGE';

Line: 68

   SELECT START_DATE
   INTO START_DATE
   FROM PA_PERIODS
   WHERE PERIOD_NAME= PA_PAXEXCPS_XMLP_PKG.START_PERIOD;

Line: 73

   SELECT END_DATE
   INTO END_DATE
   FROM PA_PERIODS
   WHERE PERIOD_NAME= PA_PAXEXCPS_XMLP_PKG.END_PERIOD;

Line: 80

   SELECT START_DATE
   INTO START_DATE
   FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp
   WHERE gps.PERIOD_NAME= START_PERIOD
   AND gps.APPLICATION_ID = 8721
   AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;

Line: 87

   SELECT END_DATE
   INTO END_DATE
   FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp
   WHERE gps.PERIOD_NAME= END_PERIOD
   AND gps.APPLICATION_ID = 8721
   AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;

Line: 99

   select meaning into ndf from pa_lookups where
    lookup_code = 'NO_DATA_FOUND' and
    lookup_type = 'MESSAGE';

Line: 115

  SELECT  gl.name
  INTO    l_name
  FROM    gl_sets_of_books gl,pa_implementations pi
  WHERE   gl.set_of_books_id = pi.set_of_books_id;

Line: 152

select substr(hr.name,1,60)
into v_ou_name
from hr_all_organization_units_tl hr, pa_implementations pi
where hr.organization_id(+) = pi.org_id and
      decode(hr.organization_id,null,'1',hr.language)=
      decode(hr.organization_id,null,'1',userenv('lang'));

Line: 234

     select gl.name
     into l_name
     from  gl_sets_of_books  gl
     where  gl.set_of_books_id  = uncst_sob;