APPS.PAY_US_TAX_UDFS_PKG SQL Statements

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

Line: 72

        hr_utility.trace('Flushing table and Inserting ');

Line: 73

        etei_data_val.DELETE;

Line: 106

     hr_utility.trace('First time Inserting ');

Line: 128

      select pet.element_type_id,
             petei.EEI_INFORMATION2,
             petei.EEI_INFORMATION4,
             petei.EEI_INFORMATION5
        from pay_element_types_f pet,
             pay_element_type_extra_info petei
       where pet.element_type_id    = p_element_type_id
         and p_date_earned            between pet.effective_start_date
                                          and pet.effective_end_date
         and petei.INFORMATION_TYPE = 'PAY_US_TAX_CALCULATION_METHOD'
         and petei.element_type_id  = pet.element_type_id;

Line: 149

   We will insert records in a plsql table for an assignment action id
   one or more element type id and for each element type id
   one or more state code and calculation method.
*/
ln_extra_info_count  number := 0;

Line: 171

                  etei_data_val.DELETE;