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_US_OVER_LIMIT_TAX_RPT_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 718: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_ee_limit;

714: ln_state_tax_limit NUMBER;
715:
716: BEGIN
717: if p_tax_type = 'SDI EE' then
718: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_ee_limit;
719: elsif p_tax_type = 'SDI ER' then
720: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_er_limit;
721: elsif p_tax_type = 'SUI EE' then
722: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_ee_limit;

Line 720: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_er_limit;

716: BEGIN
717: if p_tax_type = 'SDI EE' then
718: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_ee_limit;
719: elsif p_tax_type = 'SDI ER' then
720: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_er_limit;
721: elsif p_tax_type = 'SUI EE' then
722: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_ee_limit;
723: elsif p_tax_type = 'SUI ER' then
724: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_er_limit;

Line 722: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_ee_limit;

718: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_ee_limit;
719: elsif p_tax_type = 'SDI ER' then
720: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_er_limit;
721: elsif p_tax_type = 'SUI EE' then
722: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_ee_limit;
723: elsif p_tax_type = 'SUI ER' then
724: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_er_limit;
725: end if;
726:

Line 724: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_er_limit;

720: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sdi_er_limit;
721: elsif p_tax_type = 'SUI EE' then
722: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_ee_limit;
723: elsif p_tax_type = 'SUI ER' then
724: ln_state_tax_limit := pay_us_payroll_utils.ltr_state_tax_info(p_state_code).sui_er_limit;
725: end if;
726:
727: if ln_state_tax_limit is null then
728: ln_state_tax_limit := 0;

Line 1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;

1106: once and put them in PL/SQL table for performance */
1107:
1108: -- get 401K, SS and FUTA limits.
1109: -- #2938556
1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;

Line 1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

1107:
1108: -- get 401K, SS and FUTA limits.
1109: -- #2938556
1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;

Line 1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;

1108: -- get 401K, SS and FUTA limits.
1109: -- #2938556
1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;

Line 1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;

1109: -- #2938556
1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;

Line 1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;

1110: l_futa_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;

Line 1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;

1111: l_ss_ee_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;

Line 1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;

1112: l_ss_er_wage_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:

Line 1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;

1113: l_fed_401k_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));

Line 1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;

1114: l_fed_403b_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));

Line 1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;

1115: l_fed_457_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
1116: l_fed_401k_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
1117: l_fed_403b_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
1118: l_fed_457_catchup_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
1119: l_dcp_limit := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
1120:
1121: hr_utility.trace('FUTA : ' || to_char(l_futa_wage_limit));
1122: hr_utility.trace('SS EE : ' || to_char(l_ss_ee_wage_limit));
1123: hr_utility.trace('SS ER : ' || to_char(l_ss_er_wage_limit));

Line 1509: if (pay_us_payroll_utils.ltr_fed_tax_info.count < 1 or pay_us_payroll_utils.ltr_state_tax_info.count < 1 ) THEN

1505:
1506: g_inserted_asg_action_id_flag := 'N';
1507: l_as_of_date := to_date(l_date_prm,'YYYY/MM/DD');
1508:
1509: if (pay_us_payroll_utils.ltr_fed_tax_info.count < 1 or pay_us_payroll_utils.ltr_state_tax_info.count < 1 ) THEN
1510: hr_utility.trace('Inserting Limit Values using utilities package');
1511: pay_us_payroll_utils.populate_jit_information(p_effective_date => l_as_of_date
1512: ,p_get_federal => 'Y'
1513: ,p_get_state => 'Y');

Line 1511: pay_us_payroll_utils.populate_jit_information(p_effective_date => l_as_of_date

1507: l_as_of_date := to_date(l_date_prm,'YYYY/MM/DD');
1508:
1509: if (pay_us_payroll_utils.ltr_fed_tax_info.count < 1 or pay_us_payroll_utils.ltr_state_tax_info.count < 1 ) THEN
1510: hr_utility.trace('Inserting Limit Values using utilities package');
1511: pay_us_payroll_utils.populate_jit_information(p_effective_date => l_as_of_date
1512: ,p_get_federal => 'Y'
1513: ,p_get_state => 'Y');
1514: end if;
1515: