APPS.PA_PACRCIPF_XMLP_PKG SQL Statements

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

Line: 13

	select currency_code
	into l_curr_code
	from gl_sets_of_books
	where set_of_books_id = p_ca_set_of_books_id;

Line: 28

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

Line: 88

         SELECT  segment1
         INTO    p_project_number
         FROM    pa_projects_all
         WHERE   project_id=p_project_id ;

Line: 95

         SELECT name
         INTO   cp_proj_org_name
         FROM   hr_all_organization_units_tl
         WHERE  language=userenv('LANG')
         AND    organization_id=p_project_org;

Line: 129

SELECT
		glb.chart_of_accounts_id
  	        ,glb.name
   	 INTO
		cp_coa_id
       		,cp_company_name
   	 FROM   gl_sets_of_books glb
   	 WHERE  glb.set_of_books_id=p_ca_set_of_books_id ;

Line: 144

		     SELECT   MIN(period_open_date)
                     INTO     cp_min_open_date
		     FROM     fa_deprn_periods
		     WHERE    period_name=p_from_period;

Line: 157

		     SELECT   MAX(period_close_date)
                     INTO     cp_max_close_date
		     FROM     fa_deprn_periods
	             WHERE    period_name=p_to_period;

Line: 174

select decode(mrc_sob_type_code,'R','R','P')
into p_mrcsobtype
from gl_sets_of_books
where set_of_books_id = p_ca_set_of_books_id;