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_FEDTAX_INF_API dependencies on PAY_CA_EMP_FED_TAX_INFO_F

Line 74: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;

70: ) is
71: --
72: -- Declare cursors and local variables
73: --
74: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
75: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
76: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_ca_emp_fedtax_inf';
78: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

Line 75: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

71: --
72: -- Declare cursors and local variables
73: --
74: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
75: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
76: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_ca_emp_fedtax_inf';
78: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
79: l_rec_present varchar2(1);

Line 76: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

72: -- Declare cursors and local variables
73: --
74: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
75: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
76: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_ca_emp_fedtax_inf';
78: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
79: l_rec_present varchar2(1);
80: l_tax_credit_amount number := 0;

Line 78: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

74: l_emp_fed_tax_inf_id pay_ca_emp_fed_tax_info_f.emp_fed_tax_inf_id%TYPE;
75: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
76: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
77: l_proc varchar2(72) := g_package||'create_ca_emp_fedtax_inf';
78: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
79: l_rec_present varchar2(1);
80: l_tax_credit_amount number := 0;
81: l_additional_tax number := 0;
82: l_annual_dedn number := 0;

Line 451: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

447: --
448: -- Declare cursors and local variables
449: --
450: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
451: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
452: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
453: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
454: --
455: begin

Line 452: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

448: -- Declare cursors and local variables
449: --
450: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
451: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
452: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
453: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
454: --
455: begin
456: --

Line 453: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

449: --
450: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
451: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
452: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
453: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
454: --
455: begin
456: --
457: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 738: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;

734: --
735: -- Declare cursors and local variables
736: --
737: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
738: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
739: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
740: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
741: --
742: begin

Line 739: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;

735: -- Declare cursors and local variables
736: --
737: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
738: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
739: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
740: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
741: --
742: begin
743: --

Line 740: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;

736: --
737: l_proc varchar2(72) := g_package||'update_ca_emp_fedtax_inf';
738: l_object_version_number pay_ca_emp_fed_tax_info_f.object_version_number%TYPE;
739: l_effective_start_date pay_ca_emp_fed_tax_info_f.effective_start_date%TYPE;
740: l_effective_end_date pay_ca_emp_fed_tax_info_f.effective_end_date%TYPE;
741: --
742: begin
743: --
744: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 912: update PAY_CA_EMP_FED_TAX_INFO_F

908: end if;
909:
910: /* First update the tax rules records */
911:
912: update PAY_CA_EMP_FED_TAX_INFO_F
913: set effective_start_date = p_new_start_date
914: where assignment_id = p_assignment_id
915: and l_ef_date between effective_start_date and effective_end_date;
916:

Line 927: delete PAY_CA_EMP_FED_TAX_INFO_F

923:
924: /* Next delete any orphaned rows */
925: if p_new_start_date > p_default_date then
926: hr_utility.set_location(l_proc, 10);
927: delete PAY_CA_EMP_FED_TAX_INFO_F
928: where assignment_id = p_assignment_id
929: and p_new_start_date > effective_start_date;
930:
931:

Line 972: from pay_ca_emp_fed_tax_info_f paf

968: p_effective_date in date,
969: p_rec_present out nocopy varchar2) is
970: cursor csr_chk_assignment_rec is
971: select '1'
972: from pay_ca_emp_fed_tax_info_f paf
973: where paf.assignment_id = p_assignment_id;
974: /*
975: and p_effective_date between paf.effective_start_date and
976: paf.effective_end_date ;

Line 980: from pay_ca_emp_fed_tax_info_f fti

976: paf.effective_end_date ;
977: */
978: cursor csr_get_default_date (p_assignment number) is
979: select min(effective_start_date)
980: from pay_ca_emp_fed_tax_info_f fti
981: where fti.assignment_id = p_assignment_id;
982:
983: l_present varchar2(2);
984: l_default_date date;