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.

[Home] [Help]

APPS.PAY_CA_EMP_TAX_INF dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 322: from pay_ca_emp_fed_tax_info_f peft where

318: ,prescribed_zone_dedn_amt
319: ,fed_override_amount
320: ,fed_override_rate
321: ,fed_lsf_amount
322: from pay_ca_emp_fed_tax_info_f peft where
323: peft.assignment_id = p_assignment_id and
324: p_effective_date between peft.effective_start_date and peft.effective_end_date;
325:
326: l_tax_credit_amount number;

Line 419: from pay_ca_emp_fed_tax_info_f peft where

415: cpp_qpp_exempt_flag
416: ,fed_exempt_flag
417: ,ei_exempt_flag
418: ,tax_calc_method
419: from pay_ca_emp_fed_tax_info_f peft where
420: peft.assignment_id = p_assignment_id and
421: p_effective_date between peft.effective_start_date and peft.effective_end_date;
422:
423: CURSOR csr_get_default_province IS

Line 436: from pay_ca_emp_fed_tax_info_f pf,

432: and hl.region_1 = pcp.province_abbrev;
433:
434: CURSOR csr_get_override_province IS
435: select pcp.province_abbrev, '70-'||pcp.province_code||'-0000' geocode
436: from pay_ca_emp_fed_tax_info_f pf,
437: pay_ca_provinces_v pcp
438: where p_effective_date between pf.effective_start_date
439: and pf.effective_end_date
440: and pf.employment_province = pcp.province_abbrev

Line 522: from pay_ca_emp_fed_tax_info_f peft where

518:
519: cursor csr_tax_dfs is
520: select
521: ca_tax_information1
522: from pay_ca_emp_fed_tax_info_f peft where
523: peft.assignment_id = p_assignment_id and
524: p_effective_date between
525: peft.effective_start_date and peft.effective_end_date and
526: ca_tax_information_category = 'FED' ;

Line 562: from pay_ca_emp_fed_tax_info_f peft where

558: cursor csr_tax_date is
559: select
560: cpp_election_date
561: ,cpp_revocation_date
562: from pay_ca_emp_fed_tax_info_f peft where
563: peft.assignment_id = p_assignment_id and
564: p_effective_date between peft.effective_start_date and peft.effective_end_date;
565:
566: l_cpp_election_date date;

Line 1383: Effective_End_Date of tax records in PAY_CA_EMP_FED_TAX_INFO_F table.

1379:
1380: /*****************************************************************************
1381: Delete_fed_tax_rule procedure calls
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:

Line 1405: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;

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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

Line 1406: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

Line 1407: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

Line 1408: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1412: --

Line 1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1412: --
1413: l_exit_quietly exception;

Line 1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1412: --
1413: l_exit_quietly exception;
1414: --

Line 1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%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;
1409: l_tmp_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1410: l_tmp_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1411: l_tmp_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1412: --
1413: l_exit_quietly exception;
1414: --
1415: cursor csr_fed_rule is

Line 1417: from pay_ca_emp_fed_tax_info_f fed

1413: l_exit_quietly exception;
1414: --
1415: cursor csr_fed_rule is
1416: select fed.emp_fed_tax_inf_id, fed.object_version_number
1417: from pay_ca_emp_fed_tax_info_f fed
1418: where fed.assignment_id = p_assignment_id
1419: and l_effective_date between fed.effective_start_date
1420: and fed.effective_end_date;
1421: --

Line 1552: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

1548: l_counter number := 0;
1549: l_effective_date date;
1550: l_assignment_id per_assignments_f.assignment_id%TYPE;
1551: l_fed_object_version_number
1552: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1553: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1554: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1555: l_temp_num number;
1556: l_cnt number;

Line 1553: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

1549: l_effective_date date;
1550: l_assignment_id per_assignments_f.assignment_id%TYPE;
1551: l_fed_object_version_number
1552: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1553: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1554: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1555: l_temp_num number;
1556: l_cnt number;
1557: l_assignment_tbl assign_tbl_type;

Line 1554: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

1550: l_assignment_id per_assignments_f.assignment_id%TYPE;
1551: l_fed_object_version_number
1552: pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
1553: l_fed_eff_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
1554: l_fed_eff_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
1555: l_temp_num number;
1556: l_cnt number;
1557: l_assignment_tbl assign_tbl_type;
1558:

Line 1699: from pay_ca_emp_fed_tax_info_f peft where

1695:
1696:
1697: CURSOR csr_get_ei_flag_17b(l_assignment_id in Number,l_roe_end_date Date) IS
1698: select NVL(ei_exempt_flag,'N')
1699: from pay_ca_emp_fed_tax_info_f peft where
1700: peft.assignment_id = l_assignment_id
1701:
1702: AND l_roe_end_date between peft.effective_start_date and peft.effective_end_date;
1703: