eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_COUNTY_TAX_RULE_API SQL Statements

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

Line: 15


  Select Business_Group_Id
  From Per_Assignments_F
  Where Assignment_Id = l_assignment_id
    and l_effective_date between effective_start_date
      and effective_end_date;

Line: 23


  Select min(effective_start_date)
  From Pay_Us_Emp_Fed_Tax_Rules_f
  Where assignment_id = p_assignment_id;

Line: 294


            p_datetrack_mode         => 'INSERT',
            p_effective_start_date   => l_effective_start_date,
            p_effective_end_date     => l_effective_end_date
           );

Line: 414


procedure update_county_tax_rule
  (p_validate                       in  boolean   default false
  ,p_emp_county_tax_rule_id         in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_additional_wa_rate             in  number    default hr_api.g_number
  ,p_filing_status_code             in  varchar2  default hr_api.g_varchar2
  ,p_lit_additional_tax             in  number    default hr_api.g_number
  ,p_lit_override_amount            in  number    default hr_api.g_number
  ,p_lit_override_rate              in  number    default hr_api.g_number
  ,p_withholding_allowances         in  number    default hr_api.g_number
  ,p_lit_exempt                     in  varchar2  default hr_api.g_varchar2
  ,p_sd_exempt                      in  varchar2  default hr_api.g_varchar2
  ,p_ht_exempt                      in  varchar2  default hr_api.g_varchar2
  ,p_wage_exempt                    in  varchar2  default hr_api.g_varchar2
  ,p_school_district_code           in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ,p_attribute_category             in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                     in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute21                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute22                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute23                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute24                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute25                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute26                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute27                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute28                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute29                    in     varchar2  default hr_api.g_varchar2
  ,p_attribute30                    in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information_category       in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information1               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information2               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information3               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information4               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information5               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information6               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information7               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information8               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information9               in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information10              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information11              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information12              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information13              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information14              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information15              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information16              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information17              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information18              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information19              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information20              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information21              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information22              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information23              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information24              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information25              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information26              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information27              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information28              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information29              in     varchar2  default hr_api.g_varchar2
  ,p_cnt_information30              in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                   varchar2(72) := g_package||'update_county_tax_rule';

Line: 508


    SELECT ctr.assignment_id,
           ctr.state_code||'-'||ctr.school_district_code
    FROM   pay_us_emp_county_tax_rules_f ctr
    WHERE  ctr.emp_county_tax_rule_id = p_rule_id
    AND    p_eff_date BETWEEN ctr.effective_start_date
                          AND ctr.effective_end_date;

Line: 521


  savepoint update_county_tax_rule;

Line: 542


    pay_cnt_bk2.update_county_tax_rule_b
      (
       p_emp_county_tax_rule_id         =>  p_emp_county_tax_rule_id
      ,p_assignment_id                  =>  p_assignment_id
      ,p_state_code                     =>  p_state_code
      ,p_county_code                    =>  p_county_code
      ,p_business_group_id              =>  l_business_group_id
      ,p_additional_wa_rate             =>  p_additional_wa_rate
      ,p_filing_status_code             =>  p_filing_status_code
      ,p_jurisdiction_code              =>  l_jurisdiction_code
      ,p_lit_additional_tax             =>  p_lit_additional_tax
      ,p_lit_override_amount            =>  p_lit_override_amount
      ,p_lit_override_rate              =>  p_lit_override_rate
      ,p_withholding_allowances         =>  p_withholding_allowances
      ,p_lit_exempt                     =>  p_lit_exempt
      ,p_sd_exempt                      =>  p_sd_exempt
      ,p_ht_exempt                      =>  p_ht_exempt
      ,p_wage_exempt                    =>  p_wage_exempt
      ,p_school_district_code           =>  p_school_district_code
      ,p_object_version_number          =>  p_object_version_number
      );

Line: 566


        (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
        ,p_hook_type   => 'BP'
        );

Line: 683


    pay_cnt_bk2.update_county_tax_rule_a
      (
       p_emp_county_tax_rule_id         =>  p_emp_county_tax_rule_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_assignment_id                  =>  p_assignment_id
      ,p_state_code                     =>  p_state_code
      ,p_county_code                    =>  p_county_code
      ,p_business_group_id              =>  l_business_group_id
      ,p_additional_wa_rate             =>  p_additional_wa_rate
      ,p_filing_status_code             =>  p_filing_status_code
      ,p_jurisdiction_code              =>  l_jurisdiction_code
      ,p_lit_additional_tax             =>  p_lit_additional_tax
      ,p_lit_override_amount            =>  p_lit_override_amount
      ,p_lit_override_rate              =>  p_lit_override_rate
      ,p_withholding_allowances         =>  p_withholding_allowances
      ,p_lit_exempt                     =>  p_lit_exempt
      ,p_sd_exempt                      =>  p_sd_exempt
      ,p_ht_exempt                      =>  p_ht_exempt
      ,p_wage_exempt                    =>  p_wage_exempt
      ,p_school_district_code           =>  p_school_district_code
      ,p_object_version_number          =>  l_object_version_number
      );

Line: 709


        (p_module_name => 'UPDATE_COUNTY_TAX_RULE'
        ,p_hook_type   => 'AP'
        );

Line: 741


    ROLLBACK TO update_county_tax_rule;

Line: 756


    ROLLBACK TO update_county_tax_rule;

Line: 766


end update_county_tax_rule;

Line: 785


  l_proc varchar2(72) := g_package||'update_county_tax_rule';