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 dependencies on PAY_CA_EMP_PROV_TAX_INFO_F

Line 83: l_emp_province_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;

79: ) is
80: --
81: -- Declare cursors and local variables
82: --
83: l_emp_province_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
84: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
85: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
86: l_proc varchar2(72) := g_package||'create_ca_emp_prvtax_inf';
87: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;

Line 84: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;

80: --
81: -- Declare cursors and local variables
82: --
83: l_emp_province_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
84: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
85: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
86: l_proc varchar2(72) := g_package||'create_ca_emp_prvtax_inf';
87: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
88: l_rec_present varchar2(1);

Line 85: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;

81: -- Declare cursors and local variables
82: --
83: l_emp_province_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
84: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
85: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
86: l_proc varchar2(72) := g_package||'create_ca_emp_prvtax_inf';
87: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
88: l_rec_present varchar2(1);
89: l_tax_credit_amount number;

Line 87: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;

83: l_emp_province_tax_inf_id pay_ca_emp_prov_tax_info_f.emp_province_tax_inf_id%TYPE;
84: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
85: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
86: l_proc varchar2(72) := g_package||'create_ca_emp_prvtax_inf';
87: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
88: l_rec_present varchar2(1);
89: l_tax_credit_amount number;
90: l_additional_tax number;
91: l_annual_dedn number;

Line 505: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;

501: --
502: -- Declare cursors and local variables
503: --
504: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
505: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
506: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
507: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
508: --
509: begin

Line 506: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;

502: -- Declare cursors and local variables
503: --
504: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
505: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
506: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
507: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
508: --
509: begin
510: --

Line 507: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;

503: --
504: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
505: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
506: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
507: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
508: --
509: begin
510: --
511: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 825: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;

821: --
822: -- Declare cursors and local variables
823: --
824: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
825: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
826: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
827: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
828: --
829: begin

Line 826: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;

822: -- Declare cursors and local variables
823: --
824: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
825: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
826: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
827: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
828: --
829: begin
830: --

Line 827: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;

823: --
824: l_proc varchar2(72) := g_package||'update_ca_emp_prvtax_inf';
825: l_object_version_number pay_ca_emp_prov_tax_info_f.object_version_number%TYPE;
826: l_effective_start_date pay_ca_emp_prov_tax_info_f.effective_start_date%TYPE;
827: l_effective_end_date pay_ca_emp_prov_tax_info_f.effective_end_date%TYPE;
828: --
829: begin
830: --
831: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1007: update PAY_CA_EMP_PROV_TAX_INFO_F

1003: end if;
1004:
1005: /* First update the tax rules records */
1006:
1007: update PAY_CA_EMP_PROV_TAX_INFO_F
1008: set effective_start_date = p_new_start_date
1009: where assignment_id = p_assignment_id
1010: and l_ef_date between effective_start_date and effective_end_date
1011: and province_code = p_province_code;

Line 1023: delete PAY_CA_EMP_PROV_TAX_INFO_F

1019:
1020: /* Next delete any orphaned rows */
1021: if p_new_start_date > p_default_date then
1022: hr_utility.set_location(l_proc, 10);
1023: delete PAY_CA_EMP_PROV_TAX_INFO_F
1024: where assignment_id = p_assignment_id
1025: and p_new_start_date > effective_start_date
1026: and province_code = p_province_code;
1027:

Line 1072: from pay_ca_emp_prov_tax_info_f ptt

1068: p_effective_date in date,
1069: p_rec_present out nocopy varchar2) is
1070: cursor csr_chk_assignment_rec is
1071: select '1'
1072: from pay_ca_emp_prov_tax_info_f ptt
1073: where ptt.assignment_id = p_assignment_id
1074: /*
1075: and p_effective_date between ptt.effective_start_date and
1076: ptt.effective_end_date

Line 1082: from pay_ca_emp_prov_tax_info_f ptt

1078: and ptt.province_code = p_province_code;
1079:
1080: cursor csr_get_default_date (p_assignment number,p_province varchar2) is
1081: select min(effective_start_date)
1082: from pay_ca_emp_prov_tax_info_f ptt
1083: where ptt.assignment_id = p_assignment_id
1084: and ptt.province_code = p_province_code;
1085:
1086: