APPS.PA_PAXRWIMP_XMLP_PKG SQL Statements

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

Line: 7

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

select meaning
from pa_lookups
where lookup_type = type
and   lookup_code = code;

Line: 91

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = overtime_flag ;

Line: 107

	SELECT meaning INTO tmp_labortogl
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = Iflabortogl ;

Line: 123

	SELECT meaning INTO tmp_ifrevtogl
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = ifrevenuetogl ;

Line: 139

	SELECT meaning INTO tmp_ifusgtogl
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = ifusagetogl ;

Line: 155

	SELECT meaning INTO tmp_ceninvcoll
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code =
	centralized_invoicing_flag ;

Line: 172

	SELECT meaning INTO tmp_ifretnacc
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = ifretnacc ;

Line: 188

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO'
        AND    lookup_code = DECODE(mrc_for_fund,'U','Y', mrc_for_fund);

Line: 205

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO'
        AND    lookup_code = DECODE(reval_mrc_fund,'U','Y', reval_mrc_fund);

Line: 222

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO'
        AND    lookup_code = DECODE(mrc_for_finplan,'U','Y', mrc_for_finplan) ;

Line: 239

	SELECT meaning INTO tmp_over_flag
	FROM   fnd_lookups
	WHERE  lookup_type = 'YES_NO' AND lookup_code = ingainloss ;

Line: 255

        SELECT user_conversion_type INTO tmp_exchrate
        FROM   pa_conversion_types_v
        WHERE  conversion_type = exch_rate_type;

Line: 272

      SELECT meaning INTO tmp_over_flag
        FROM  pa_lookups
       WHERE  lookup_type = 'PA_CUST_ACC_REL_CODE'
         AND  lookup_code = cust_acc_rel_code;

Line: 293

      SELECT meaning
        INTO temp
        FROM fnd_lookups
       WHERE lookup_type = 'YES_NO'
         AND lookup_code = credit_memo_reason_flag;