APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 569: from pay_ca_emp_prov_tax_info_f pept where

565: ,additional_tax
566: ,prov_override_rate
567: ,prov_override_amount
568: ,prov_lsp_amount
569: from pay_ca_emp_prov_tax_info_f pept where
570: pept.assignment_id = p_assignment_id and
571: p_effective_date between pept.effective_start_date and pept.effective_end_date and
572: pept.province_code = p_province_abbrev;
573:

Line 690: from pay_ca_emp_prov_tax_info_f pept where

686: ,wc_exempt_flag
687: ,qpp_exempt_flag
688: ,tax_calc_method
689: ,ppip_exempt_flag
690: from pay_ca_emp_prov_tax_info_f pept where
691: pept.assignment_id = p_assignment_id and
692: p_effective_date between pept.effective_start_date and pept.effective_end_date and
693: pept.province_code = p_province_abbrev;
694:

Line 784: from pay_ca_emp_prov_tax_info_f pept where

780: cursor csr_prov_tax_dfs is
781: select
782: ca_tax_information1,
783: ca_tax_information2
784: from pay_ca_emp_prov_tax_info_f pept where
785: pept.assignment_id = p_assignment_id and
786: p_effective_date between
787: pept.effective_start_date and pept.effective_end_date and
788: -- ca_tax_information_category = p_province_abbrev;

Line 1166: Effective_End_Date of tax records in PAY_CA_EMP_PROV_TAX_INFO_F table.

1162: pay_ca_emp_fedtax_inf_api.delete_ca_emp_fedtax_inf procedure for updating
1163: Effective_End_Date of tax records in PAY_CA_EMP_FED_TAX_INFO_F table.
1164:
1165: pay_ca_emp_prvtax_inf_api.delete_ca_emp_prvtax_inf procedure for updating
1166: Effective_End_Date of tax records in PAY_CA_EMP_PROV_TAX_INFO_F table.
1167:
1168: *****************************************************************************/
1169:
1170: procedure delete_fed_tax_rule

Line 1184: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;

1180: -- Declare cursors and local variables
1181: --
1182: l_proc varchar2(72) := 'delete_fed_tax_rule';
1183: l_effective_date date;
1184: l_emp_prov_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
1185: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
1186: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1187: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1188: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

Line 1204: from pay_ca_emp_prov_tax_info_f sta

1200: and fed.effective_end_date;
1201: --
1202: cursor csr_prov_rule is
1203: select sta.emp_province_tax_inf_id, sta.object_version_number
1204: from pay_ca_emp_prov_tax_info_f sta
1205: where sta.assignment_id = p_assignment_id
1206: and l_effective_date between sta.effective_start_date
1207: and sta.effective_end_date;
1208: --