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

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

Line: 432


procedure update_ca_emp_prvtax_inf
  (p_validate                       in  boolean   default false
  ,p_emp_province_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_province_code                  in  varchar2  default hr_api.g_varchar2
  ,p_jurisdiction_code              in  varchar2  default hr_api.g_varchar2
  ,p_tax_credit_amount              in  number    default hr_api.g_number
  ,p_basic_exemption_flag           in  varchar2  default hr_api.g_varchar2
  ,p_deduction_code                 in  varchar2  default hr_api.g_varchar2
  ,p_extra_info_not_provided        in  varchar2  default hr_api.g_varchar2
  ,p_marriage_status                in  varchar2  default hr_api.g_varchar2
  ,p_no_of_infirm_dependants        in  number    default hr_api.g_number
  ,p_non_resident_status            in  varchar2  default hr_api.g_varchar2
  ,p_disability_status              in  varchar2  default hr_api.g_varchar2
  ,p_no_of_dependants               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_additional_tax                 in  number    default hr_api.g_number
  ,p_prov_override_rate             in  number    default hr_api.g_number
  ,p_prov_override_amount           in  number    default hr_api.g_number
  ,p_prov_exempt_flag               in  varchar2  default hr_api.g_varchar2
  ,p_pmed_exempt_flag               in  varchar2  default hr_api.g_varchar2
  ,p_wc_exempt_flag                 in  varchar2  default hr_api.g_varchar2
  ,p_qpp_exempt_flag                in  varchar2  default hr_api.g_varchar2
  ,p_tax_calc_method                in  varchar2  default hr_api.g_varchar2
  ,p_other_tax_credit               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_prov_lsp_amount                in  number    default hr_api.g_number
  ,p_effective_date                 in  date
  ,p_datetrack_mode                 in  varchar2
  ,p_ppip_exempt_flag                in  varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';

Line: 515


  savepoint update_ca_emp_prvtax_inf;

Line: 528


    pay_ca_emp_prvtax_inf_bk2.update_ca_emp_prvtax_inf_b
      (
       p_emp_province_tax_inf_id        =>  p_emp_province_tax_inf_id
      ,p_legislation_code               =>  p_legislation_code
      ,p_assignment_id                  =>  p_assignment_id
      ,p_business_group_id              =>  p_business_group_id
      ,p_province_code                  =>  p_province_code
      ,p_jurisdiction_code              =>  p_jurisdiction_code
      ,p_tax_credit_amount              =>  p_tax_credit_amount
      ,p_basic_exemption_flag           =>  p_basic_exemption_flag
      ,p_deduction_code                 =>  p_deduction_code
      ,p_extra_info_not_provided        =>  p_extra_info_not_provided
      ,p_marriage_status                =>  p_marriage_status
      ,p_no_of_infirm_dependants        =>  p_no_of_infirm_dependants
      ,p_non_resident_status            =>  p_non_resident_status
      ,p_disability_status              =>  p_disability_status
      ,p_no_of_dependants               =>  p_no_of_dependants
      ,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_additional_tax                 =>  p_additional_tax
      ,p_prov_override_rate             =>  p_prov_override_rate
      ,p_prov_override_amount           =>  p_prov_override_amount
      ,p_prov_exempt_flag               =>  p_prov_exempt_flag
      ,p_pmed_exempt_flag               =>  p_pmed_exempt_flag
      ,p_wc_exempt_flag                 =>  p_wc_exempt_flag
      ,p_qpp_exempt_flag                =>  p_qpp_exempt_flag
      ,p_tax_calc_method                =>  p_tax_calc_method
      ,p_other_tax_credit               =>  p_other_tax_credit
      ,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_prov_lsp_amount               =>  p_prov_lsp_amount
    ,p_effective_date                      => trunc(p_effective_date)
    ,p_datetrack_mode                      => p_datetrack_mode
      );

Line: 597


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

Line: 682


    pay_ca_emp_prvtax_inf_bk2.update_ca_emp_prvtax_inf_a
      (
       p_emp_province_tax_inf_id        =>  p_emp_province_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_province_code                  =>  p_province_code
      ,p_jurisdiction_code              =>  p_jurisdiction_code
      ,p_tax_credit_amount              =>  p_tax_credit_amount
      ,p_basic_exemption_flag           =>  p_basic_exemption_flag
      ,p_deduction_code                 =>  p_deduction_code
      ,p_extra_info_not_provided        =>  p_extra_info_not_provided
      ,p_marriage_status                =>  p_marriage_status
      ,p_no_of_infirm_dependants        =>  p_no_of_infirm_dependants
      ,p_non_resident_status            =>  p_non_resident_status
      ,p_disability_status              =>  p_disability_status
      ,p_no_of_dependants               =>  p_no_of_dependants
      ,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_additional_tax                 =>  p_additional_tax
      ,p_prov_override_rate             =>  p_prov_override_rate
      ,p_prov_override_amount           =>  p_prov_override_amount
      ,p_prov_exempt_flag               =>  p_prov_exempt_flag
      ,p_pmed_exempt_flag               =>  p_pmed_exempt_flag
      ,p_wc_exempt_flag                 =>  p_wc_exempt_flag
      ,p_qpp_exempt_flag                =>  p_qpp_exempt_flag
      ,p_tax_calc_method                =>  p_tax_calc_method
      ,p_other_tax_credit               =>  p_other_tax_credit
      ,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_prov_lsp_amount               =>  p_prov_lsp_amount
      ,p_effective_date                     => trunc(p_effective_date)
      ,p_datetrack_mode                     => p_datetrack_mode
      );

Line: 753


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

Line: 785


    ROLLBACK TO update_ca_emp_prvtax_inf;

Line: 797


    ROLLBACK TO update_ca_emp_prvtax_inf;

Line: 807


end update_ca_emp_prvtax_inf;

Line: 812


procedure delete_ca_emp_prvtax_inf
  (p_validate                       in  boolean  default false
  ,p_emp_province_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_prvtax_inf';

Line: 835


  savepoint delete_ca_emp_prvtax_inf;

Line: 849


    pay_ca_emp_prvtax_inf_bk3.delete_ca_emp_prvtax_inf_b
      (
       p_emp_province_tax_inf_id        =>  p_emp_province_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: 859


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

Line: 883


    pay_ca_emp_prvtax_inf_bk3.delete_ca_emp_prvtax_inf_a
      (
       p_emp_province_tax_inf_id        =>  p_emp_province_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: 895


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

Line: 921


    ROLLBACK TO delete_ca_emp_prvtax_inf;

Line: 934


    ROLLBACK TO delete_ca_emp_prvtax_inf;

Line: 944


end delete_ca_emp_prvtax_inf;

Line: 1005


       /* First update the tax rules records */

  update PAY_CA_EMP_PROV_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
       and  province_code = p_province_code;

Line: 1020


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

Line: 1023


               delete PAY_CA_EMP_PROV_TAX_INFO_F
               where  assignment_id = p_assignment_id
               and    p_new_start_date >  effective_start_date
               and province_code = p_province_code;

Line: 1071


       select  '1'
       from   pay_ca_emp_prov_tax_info_f   ptt
       where  ptt.assignment_id         = p_assignment_id
/*
       and    p_effective_date between ptt.effective_start_date and
                                     ptt.effective_end_date
*/
       and    ptt.province_code = p_province_code;

Line: 1081


         select min(effective_start_date)
           from   pay_ca_emp_prov_tax_info_f   ptt
             where    ptt.assignment_id         = p_assignment_id
               and    ptt.province_code = p_province_code;

Line: 1129


       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: 1135


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

Line: 1186


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