APPS.PA_PAXEXCPD_XMLP_PKG SQL Statements

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

Line: 40

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

Line: 43

select nvl(fnd_profile.value_specific('PA_EN_NEW_GLDATE_DERIVATION'),'N') into pa_new_gl_date from dual;

Line: 64

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

Line: 72

   SELECT START_DATE
   INTO START_DATE
   FROM PA_PERIODS
   WHERE PERIOD_NAME= START_PERIOD;

Line: 77

   SELECT END_DATE
   INTO END_DATE
   FROM PA_PERIODS
   WHERE PERIOD_NAME= END_PERIOD;

Line: 84

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

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

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

Line: 119

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

	select hr.name
	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: 258

	select hr.name
	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: 278

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

Line: 298

             select gl.name
             into  v_name
             from  gl_sets_of_books gl
             where  gl.set_of_books_id  = receipt_books;