APPS.PAY_SE_TAX_TABLE_UPLOAD SQL Statements

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

Line: 31

         SELECT legislation_code
           FROM per_business_groups
          WHERE business_group_id = p_business_group;

Line: 119

         SELECT legislation_code
           FROM per_business_groups
          WHERE business_group_id = p_business_group;

Line: 127

         SELECT range_table_id
               ,object_version_number
           FROM pay_range_tables_f
          WHERE legislation_code = p_legislation_code
            --AND    BUSINESS_GROUP_ID       = p_business_group
            AND effective_start_date >=
                     TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS')
            AND effective_end_date <=
                       TO_DATE (p_effective_end_date, 'YYYY/MM/DD HH24:MI:SS');

Line: 139

         SELECT range_id
               ,object_version_number
           FROM pay_ranges_f
          WHERE range_table_id = p_range_table_id
            AND effective_start_date >=
                     TO_DATE (p_effective_start_date, 'YYYY/MM/DD HH24:MI:SS')
            AND effective_end_date <=
                       TO_DATE (p_effective_end_date, 'YYYY/MM/DD HH24:MI:SS');

Line: 164

         DELETE FROM pay_range_temp;

Line: 180

               pay_range_api.delete_range (CHILD.range_id
                                          ,CHILD.object_version_number
                                          );

Line: 185

            pay_range_table_api.delete_range_table
                                                 (MASTER.range_table_id
                                                 ,MASTER.object_version_number
                                                 );

Line: 248

         SELECT 'Y'
           FROM pay_range_tables_f
          WHERE legislation_code = p_legislation_code
            AND  period_frequency    = p_tax_table_type
            --AND  BUSINESS_GROUP_ID    = p_business_group
            AND effective_start_date = p_effective_start_date;

Line: 257

         SELECT 'Y'
               ,effective_start_date
               ,effective_end_date
           FROM pay_range_tables_f
          WHERE legislation_code = p_legislation_code
            AND  period_frequency    = p_tax_table_type
            --AND  BUSINESS_GROUP_ID    = p_business_group
            AND effective_start_date > p_effective_start_date;

Line: 272

         SELECT range_table_id
               ,object_version_number
           FROM pay_range_tables_f
          WHERE legislation_code = p_legislation_code
            --AND  BUSINESS_GROUP_ID    = p_business_group
            AND effective_start_date < p_effective_start_date
            AND range_table_number = l_range_table_number
            AND row_value_uom = l_row_value_uom
            AND period_frequency = l_period_frequency
            AND effective_end_date = c_end_of_time;

Line: 285

         SELECT range_id
           FROM pay_ranges_f
          WHERE range_table_id = l_range_table_id
            AND effective_start_date < p_effective_start_date
            AND effective_end_date <> c_end_of_time;

Line: 293

         SELECT DISTINCT range_table_number
                        ,period_frequency
                        ,row_value_uom
                    FROM pay_range_temp;

Line: 304

         SELECT low_band
               ,high_band
               ,amount1
               ,amount2
               ,amount3
               ,amount4
               ,amount5
               ,amount6
               ,amount7
               ,amount8
           FROM pay_range_temp
          WHERE range_table_number = l_range_table_num
            AND period_frequency = l_period_frequency
            AND row_value_uom = l_row_value_uom;

Line: 321

         SELECT range_table_id
               ,range_table_number
               ,period_frequency
               ,row_value_uom
           FROM pay_range_tables_f
          WHERE legislation_code = p_legislation_code
            --AND  BUSINESS_GROUP_ID    = p_business_group
            AND effective_start_date = p_effective_start_date
            AND effective_end_date = c_end_of_time;

Line: 392

            pay_range_table_api.update_range_table
                           (p_range_table_id             => l_csr_range_table_id
                           ,p_effective_end_date         =>   p_effective_start_date
                                                            - 1
                           ,p_object_version_number      => l_dummy
                           );

Line: 494

         SELECT range_id
               ,object_version_number
           FROM pay_ranges_f
          WHERE range_table_id = p_range_table_id
            AND effective_start_date < p_effective_start_date
            AND effective_end_date = c_end_of_time;

Line: 513

         pay_range_api.update_range
                          (p_range_table_id             => p_range_table_id
                          ,p_effective_end_date         =>   p_effective_start_date
                                                           - 1
                          ,p_object_version_number      => l_object_version_number
                          ,p_range_id                   => l_range_id
                          );

Line: 629

            INSERT INTO pay_range_temp
                        (range_id
                        ,range_table_number
                        ,row_value_uom
                        ,period_frequency
                        ,earnings_type
                        ,low_band
                        ,high_band
                        ,amount1
                        ,amount2
                        ,amount3
                        ,amount4
                        ,amount5
                        ,amount6
                        ,amount7
                        ,amount8
                        )
                 VALUES (pay_ranges_f_s.NEXTVAL
                        ,l_range_table_number
                        ,l_row_value_uom
                        ,l_period_frequency
                        ,NULL
                        ,l_low_band
                        ,l_high_band
                        ,l_amount1
                        ,l_amount2
                        ,l_amount3
                        ,l_amount4
                        ,l_amount5
                        ,l_amount6
                        ,l_amount7
                        ,l_amount8
                        );