APPS.TRR_ENGINE_PKG SQL Statements

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

Line: 20

   select count(*) gre_size, puar.tax_unit_id gre_id, htu.name gre_name
   from   pay_us_asg_reporting puar,
          hr_tax_units_v htu
   where  puar.tax_unit_id=htu.tax_unit_id
   and    htu.business_group_id=c_business_group_id
   and    substr(puar.jurisdiction_code,1,2)=
                   nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
   and    htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
   group by puar.tax_unit_id,htu.name
   order by count(*);

Line: 62

  select number_of_copies,
        printer,
        print_style,
        save_output_flag
  into  copies_buffer,
        printer_buffer,
        style_buffer,
        save_result
  from  fnd_concurrent_requests
  where request_id = fnd_number.canonical_to_number(req_id);

Line: 84

        select pdb.run_balance_status
          into l_valid_status
        from   pay_defined_balances pdb,
               pay_balance_types pbt,
               pay_balance_dimensions pbd
        where  pdb.legislation_code = 'US'
           and pdb.save_run_balance = 'Y'
           and pdb.run_balance_status is not null
           and pdb.balance_type_id = pbt.balance_type_id
           and pbd.balance_dimension_id = pdb.balance_dimension_id
           and pbt.balance_name = 'SIT Withheld'
           and pbd.database_item_suffix = '_GRE_JD_RUN';

Line: 247

   select count(*) gre_size,puar.tax_unit_id gre_id,htu.name gre_name
   from   pay_us_asg_reporting puar,
          hr_tax_units_v htu
   where  puar.tax_unit_id=htu.tax_unit_id
   and    htu.business_group_id=c_business_group_id
   and    substr(puar.jurisdiction_code,1,2)=
                   nvl(c_jurisdiction_code,substr(puar.jurisdiction_code,1,2))
   and    htu.tax_unit_id=nvl(c_tax_unit_id,htu.tax_unit_id)
   group by puar.tax_unit_id,htu.name
   order by count(*);

Line: 284

  select number_of_copies,
        printer,
        print_style,
        save_output_flag
  into  copies_buffer,
        printer_buffer,
        style_buffer,
        save_result
  from  fnd_concurrent_requests
  where request_id = fnd_number.canonical_to_number(req_id);