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_CA_EMP_FEDTAX_INF_API SQL Statements

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

Line: 395


procedure update_ca_emp_fedtax_inf
  (p_validate                       in  boolean   default false
  ,p_emp_fed_tax_inf_id             in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_legislation_code               in  varchar2  default hr_api.g_varchar2
  ,p_assignment_id                  in  number    default hr_api.g_number
  ,p_business_group_id              in  number    default hr_api.g_number
  ,p_employment_province            in  varchar2  default hr_api.g_varchar2
  ,p_tax_credit_amount              in  number    default hr_api.g_number
  ,p_claim_code                     in  varchar2  default hr_api.g_varchar2
  ,p_basic_exemption_flag           in  varchar2  default hr_api.g_varchar2
  ,p_additional_tax                 in  number    default hr_api.g_number
  ,p_annual_dedn                    in  number    default hr_api.g_number
  ,p_total_expense_by_commission    in  number    default hr_api.g_number
  ,p_total_remnrtn_by_commission    in  number    default hr_api.g_number
  ,p_prescribed_zone_dedn_amt       in  number    default hr_api.g_number
  ,p_other_fedtax_credits           in  varchar2  default hr_api.g_varchar2
  ,p_cpp_qpp_exempt_flag            in  varchar2  default hr_api.g_varchar2
  ,p_fed_exempt_flag                in  varchar2  default hr_api.g_varchar2
  ,p_ei_exempt_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_tax_calc_method                in  varchar2  default hr_api.g_varchar2
  ,p_fed_override_amount            in  number    default hr_api.g_number
  ,p_fed_override_rate              in  number    default hr_api.g_number
  ,p_ca_tax_information_category    in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information1            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information2            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information3            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information4            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information5            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information6            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information7            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information8            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information9            in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information10           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information11           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information12           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information13           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information14           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information15           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information16           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information17           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information18           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information19           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information20           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information21           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information22           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information23           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information24           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information25           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information26           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information27           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information28           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information29           in  varchar2  default hr_api.g_varchar2
  ,p_ca_tax_information30           in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_fed_lsf_amount                in  number    default hr_api.g_number
  ,p_cpp_election_date              in date  default null     --For Bug Number 13258136, defaulted for Bug 13690645
  ,p_cpp_revocation_date            in date  default null     --For Bug Number 13258136, defaulted for Bug 13690645
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';

Line: 471


  savepoint update_ca_emp_fedtax_inf;

Line: 484


    pay_ca_emp_fedtax_inf_bk2.update_ca_emp_fedtax_inf_b
      (
       p_emp_fed_tax_inf_id             =>  p_emp_fed_tax_inf_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_assignment_id                  =>  p_assignment_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_employment_province            =>  p_employment_province
      ,p_tax_credit_amount              =>  p_tax_credit_amount
      ,p_claim_code                     =>  p_claim_code
      ,p_basic_exemption_flag           =>  p_basic_exemption_flag
      ,p_additional_tax                 =>  p_additional_tax
      ,p_annual_dedn                    =>  p_annual_dedn
      ,p_total_expense_by_commission    =>  p_total_expense_by_commission
      ,p_total_remnrtn_by_commission    =>  p_total_remnrtn_by_commission
      ,p_prescribed_zone_dedn_amt       =>  p_prescribed_zone_dedn_amt
      ,p_other_fedtax_credits           =>  p_other_fedtax_credits
      ,p_cpp_qpp_exempt_flag            =>  p_cpp_qpp_exempt_flag
      ,p_fed_exempt_flag                =>  p_fed_exempt_flag
      ,p_ei_exempt_flag                 =>  p_ei_exempt_flag
      ,p_tax_calc_method                =>  p_tax_calc_method
      ,p_fed_override_amount            =>  p_fed_override_amount
      ,p_fed_override_rate              =>  p_fed_override_rate
      ,p_ca_tax_information_category    =>  p_ca_tax_information_category
      ,p_ca_tax_information1            =>  p_ca_tax_information1
      ,p_ca_tax_information2            =>  p_ca_tax_information2
      ,p_ca_tax_information3            =>  p_ca_tax_information3
      ,p_ca_tax_information4            =>  p_ca_tax_information4
      ,p_ca_tax_information5            =>  p_ca_tax_information5
      ,p_ca_tax_information6            =>  p_ca_tax_information6
      ,p_ca_tax_information7            =>  p_ca_tax_information7
      ,p_ca_tax_information8            =>  p_ca_tax_information8
      ,p_ca_tax_information9            =>  p_ca_tax_information9
      ,p_ca_tax_information10           =>  p_ca_tax_information10
      ,p_ca_tax_information11           =>  p_ca_tax_information11
      ,p_ca_tax_information12           =>  p_ca_tax_information12
      ,p_ca_tax_information13           =>  p_ca_tax_information13
      ,p_ca_tax_information14           =>  p_ca_tax_information14
      ,p_ca_tax_information15           =>  p_ca_tax_information15
      ,p_ca_tax_information16           =>  p_ca_tax_information16
      ,p_ca_tax_information17           =>  p_ca_tax_information17
      ,p_ca_tax_information18           =>  p_ca_tax_information18
      ,p_ca_tax_information19           =>  p_ca_tax_information19
      ,p_ca_tax_information20           =>  p_ca_tax_information20
      ,p_ca_tax_information21           =>  p_ca_tax_information21
      ,p_ca_tax_information22           =>  p_ca_tax_information22
      ,p_ca_tax_information23           =>  p_ca_tax_information23
      ,p_ca_tax_information24           =>  p_ca_tax_information24
      ,p_ca_tax_information25           =>  p_ca_tax_information25
      ,p_ca_tax_information26           =>  p_ca_tax_information26
      ,p_ca_tax_information27           =>  p_ca_tax_information27
      ,p_ca_tax_information28           =>  p_ca_tax_information28
      ,p_ca_tax_information29           =>  p_ca_tax_information29
      ,p_ca_tax_information30           =>  p_ca_tax_information30
      ,p_object_version_number          =>  p_object_version_number
      ,p_fed_lsf_amount                 =>  p_fed_lsf_amount
      ,p_cpp_election_date              =>  p_cpp_election_date             --For Bug Number 13258136
      ,p_cpp_revocation_date            =>  p_cpp_revocation_date           --For Bug Number 13258136
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 547


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

Line: 624


    pay_ca_emp_fedtax_inf_bk2.update_ca_emp_fedtax_inf_a
      (
       p_emp_fed_tax_inf_id             =>  p_emp_fed_tax_inf_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_legislation_code               =>  p_legislation_code
      ,p_assignment_id                  =>  p_assignment_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_employment_province            =>  p_employment_province
      ,p_tax_credit_amount              =>  p_tax_credit_amount
      ,p_claim_code                     =>  p_claim_code
      ,p_basic_exemption_flag           =>  p_basic_exemption_flag
      ,p_additional_tax                 =>  p_additional_tax
      ,p_annual_dedn                    =>  p_annual_dedn
      ,p_total_expense_by_commission    =>  p_total_expense_by_commission
      ,p_total_remnrtn_by_commission    =>  p_total_remnrtn_by_commission
      ,p_prescribed_zone_dedn_amt       =>  p_prescribed_zone_dedn_amt
      ,p_other_fedtax_credits           =>  p_other_fedtax_credits
      ,p_cpp_qpp_exempt_flag            =>  p_cpp_qpp_exempt_flag
      ,p_fed_exempt_flag                =>  p_fed_exempt_flag
      ,p_ei_exempt_flag                 =>  p_ei_exempt_flag
      ,p_tax_calc_method                =>  p_tax_calc_method
      ,p_fed_override_amount            =>  p_fed_override_amount
      ,p_fed_override_rate              =>  p_fed_override_rate
      ,p_ca_tax_information_category    =>  p_ca_tax_information_category
      ,p_ca_tax_information1            =>  p_ca_tax_information1
      ,p_ca_tax_information2            =>  p_ca_tax_information2
      ,p_ca_tax_information3            =>  p_ca_tax_information3
      ,p_ca_tax_information4            =>  p_ca_tax_information4
      ,p_ca_tax_information5            =>  p_ca_tax_information5
      ,p_ca_tax_information6            =>  p_ca_tax_information6
      ,p_ca_tax_information7            =>  p_ca_tax_information7
      ,p_ca_tax_information8            =>  p_ca_tax_information8
      ,p_ca_tax_information9            =>  p_ca_tax_information9
      ,p_ca_tax_information10           =>  p_ca_tax_information10
      ,p_ca_tax_information11           =>  p_ca_tax_information11
      ,p_ca_tax_information12           =>  p_ca_tax_information12
      ,p_ca_tax_information13           =>  p_ca_tax_information13
      ,p_ca_tax_information14           =>  p_ca_tax_information14
      ,p_ca_tax_information15           =>  p_ca_tax_information15
      ,p_ca_tax_information16           =>  p_ca_tax_information16
      ,p_ca_tax_information17           =>  p_ca_tax_information17
      ,p_ca_tax_information18           =>  p_ca_tax_information18
      ,p_ca_tax_information19           =>  p_ca_tax_information19
      ,p_ca_tax_information20           =>  p_ca_tax_information20
      ,p_ca_tax_information21           =>  p_ca_tax_information21
      ,p_ca_tax_information22           =>  p_ca_tax_information22
      ,p_ca_tax_information23           =>  p_ca_tax_information23
      ,p_ca_tax_information24           =>  p_ca_tax_information24
      ,p_ca_tax_information25           =>  p_ca_tax_information25
      ,p_ca_tax_information26           =>  p_ca_tax_information26
      ,p_ca_tax_information27           =>  p_ca_tax_information27
      ,p_ca_tax_information28           =>  p_ca_tax_information28
      ,p_ca_tax_information29           =>  p_ca_tax_information29
      ,p_ca_tax_information30           =>  p_ca_tax_information30
      ,p_object_version_number          =>  l_object_version_number
      ,p_fed_lsf_amount                 =>  p_fed_lsf_amount
      ,p_cpp_election_date              =>  p_cpp_election_date             --For Bug Number 13258136
      ,p_cpp_revocation_date            =>  p_cpp_revocation_date           --For Bug Number 13258136
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_datetrack_mode                 =>  p_datetrack_mode
      );

Line: 689


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

Line: 721


    ROLLBACK TO update_ca_emp_fedtax_inf;

Line: 733


    ROLLBACK TO update_ca_emp_fedtax_inf;

Line: 736


end update_ca_emp_fedtax_inf;

Line: 741


procedure delete_ca_emp_fedtax_inf
  (p_validate                       in  boolean  default false
  ,p_emp_fed_tax_inf_id             in  number
  ,p_effective_start_date           out nocopy date
  ,p_effective_end_date             out nocopy date
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';

Line: 764


  savepoint delete_ca_emp_fedtax_inf;

Line: 778


    pay_ca_emp_fedtax_inf_bk3.delete_ca_emp_fedtax_inf_b
      (
       p_emp_fed_tax_inf_id             =>  p_emp_fed_tax_inf_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 788


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

Line: 812


    pay_ca_emp_fedtax_inf_bk3.delete_ca_emp_fedtax_inf_a
      (
       p_emp_fed_tax_inf_id             =>  p_emp_fed_tax_inf_id
      ,p_effective_start_date           =>  l_effective_start_date
      ,p_effective_end_date             =>  l_effective_end_date
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 824


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

Line: 850


    ROLLBACK TO delete_ca_emp_fedtax_inf;

Line: 863


    ROLLBACK TO delete_ca_emp_fedtax_inf;

Line: 866


end delete_ca_emp_fedtax_inf;

Line: 926


       /* First update the tax rules records */

  update PAY_CA_EMP_FED_TAX_INFO_F
       set    effective_start_date = p_new_start_date
       where  assignment_id = p_assignment_id
       and    l_ef_date between effective_start_date and effective_end_date;

Line: 940


 /* Next delete any orphaned rows */
       if p_new_start_date > p_default_date then
               hr_utility.set_location(l_proc, 10);

Line: 943


               delete PAY_CA_EMP_FED_TAX_INFO_F
               where  assignment_id = p_assignment_id
               and    p_new_start_date >  effective_start_date;

Line: 987


       select  '1'
       from   pay_ca_emp_fed_tax_info_f   paf
       where  paf.assignment_id         = p_assignment_id;

Line: 995


         select min(effective_start_date)
           from   pay_ca_emp_fed_tax_info_f   fti
             where  fti.assignment_id         = p_assignment_id;

Line: 1043


       select  paf.location_id
       from   PER_ASSIGNMENTS_F   paf
       where  paf.assignment_id         = p_assignment_id
       and    p_effective_date between paf.effective_start_date and
                                     paf.effective_end_date ;

Line: 1049


   select hrl.country from hr_locations hrl
   where hrl.location_id = p_location_id;

Line: 1104


select '1' from hr_lookups lkp
where lkp.lookup_code = p_employment_province
and   lkp.lookup_type = 'CA_PROVINCE';