APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 616: from pay_ca_emp_prov_tax_info_f pept where

612: ,additional_tax
613: ,prov_override_rate
614: ,prov_override_amount
615: ,prov_lsp_amount
616: from pay_ca_emp_prov_tax_info_f pept where
617: pept.assignment_id = p_assignment_id and
618: p_effective_date between pept.effective_start_date and pept.effective_end_date and
619: pept.province_code = p_province_abbrev;
620:

Line 737: from pay_ca_emp_prov_tax_info_f pept where

733: ,wc_exempt_flag
734: ,qpp_exempt_flag
735: ,tax_calc_method
736: ,ppip_exempt_flag
737: from pay_ca_emp_prov_tax_info_f pept where
738: pept.assignment_id = p_assignment_id and
739: p_effective_date between pept.effective_start_date and pept.effective_end_date and
740: pept.province_code = p_province_abbrev;
741:

Line 831: from pay_ca_emp_prov_tax_info_f pept where

827: cursor csr_prov_tax_dfs is
828: select
829: ca_tax_information1,
830: ca_tax_information2
831: from pay_ca_emp_prov_tax_info_f pept where
832: pept.assignment_id = p_assignment_id and
833: p_effective_date between
834: pept.effective_start_date and pept.effective_end_date and
835: -- ca_tax_information_category = p_province_abbrev;

Line 1386: Effective_End_Date of tax records in PAY_CA_EMP_PROV_TAX_INFO_F table.

1382: pay_ca_emp_fedtax_inf_api.delete_ca_emp_fedtax_inf procedure for updating
1383: Effective_End_Date of tax records in PAY_CA_EMP_FED_TAX_INFO_F table.
1384:
1385: pay_ca_emp_prvtax_inf_api.delete_ca_emp_prvtax_inf procedure for updating
1386: Effective_End_Date of tax records in PAY_CA_EMP_PROV_TAX_INFO_F table.
1387:
1388: *****************************************************************************/
1389:
1390: procedure delete_fed_tax_rule

Line 1404: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;

1400: -- Declare cursors and local variables
1401: --
1402: l_proc varchar2(72) := 'delete_fed_tax_rule';
1403: l_effective_date date;
1404: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
1405: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
1406: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1407: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1408: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

Line 1424: from pay_ca_emp_prov_tax_info_f sta

1420: and fed.effective_end_date;
1421: --
1422: cursor csr_prov_rule is
1423: select sta.emp_province_tax_inf_id, sta.object_version_number
1424: from pay_ca_emp_prov_tax_info_f sta
1425: where sta.assignment_id = p_assignment_id
1426: and l_effective_date between sta.effective_start_date
1427: and sta.effective_end_date;
1428: --