APPS.PAY_PAYSUDAP_PKG SQL Statements

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

Line: 14

   select 'Y'
   from   pay_accrual_bands
   where (p_lower_limit between lower_limit and upper_limit
     or
          p_upper_limit between lower_limit and upper_limit
     or
          lower_limit between p_lower_limit and p_upper_limit
     or
          upper_limit between p_lower_limit and p_upper_limit)
   and  ((p_accrual_band_id is null)
     or  (p_accrual_band_id is not null
      and accrual_band_id <> p_accrual_band_id))
   and    accrual_plan_id = p_accrual_plan_id;

Line: 57

   select 'Y'
   from   pay_accrual_bands
   where  accrual_plan_id = p_accrual_plan_id
   and   (p_accrual_band_id is null
     or   p_accrual_band_id is not null
      and accrual_band_id <> p_accrual_band_id)
   and  ((p_ceiling is null
      and ceiling is not null)
     or  (p_ceiling is not null
      and ceiling is null));