APPS.AR_DEPOSIT_VAL_PVT SQL Statements

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

Line: 41

         SELECT batch_source_id
         INTO   l_dummy
         FROM   ra_batch_sources
         WHERE  batch_source_id  = p_batch_source_id;

Line: 134

     SELECT 'Y'
     INTO   l_exchange_rate_valid
     FROM   gl_daily_conversion_types
     WHERE  conversion_type = p_exchange_rate_type;

Line: 214

   SELECT 'Y'
   INTO   l_currency_valid
   FROM   fnd_currencies
   WHERE  p_currency_code = currency_code;

Line: 343

cursor c_status_cur is   SELECT lookup_code CODE
                         FROM AR_LOOKUPS
                         WHERE LOOKUP_TYPE = 'INVOICE_TRX_STATUS';

Line: 351

        select lookup_code CODE
        from ar_lookups
        where lookup_type = 'TAX_CONTROL_FLAG' and
        lookup_code <>
        decode(nvl(ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag,'Y'),
                'Y', '!@#$', 'N', 'E');