[Home] [Help]
119: SUI ER Experience Rate 2 and L_second_half_rate
120: gets the value from SUI ER Experience Rate 1
121: 07-Feb-2011 rosuri 10350917 115.37 Modified the procedure prc_state_balances.
122: Added a new variable l_assignment_id which is used as
123: parameter in function call pay_us_tax_bals_pkg.us_tax_balance.
124: 07-Mar-2011 rosuri 10631126 115.38 SS_ER_RATE and SS_EE_RATE are not equal from 01-JAN-2011
125: Commented the messege "YTD SS EE Withheld does not =
126: YTD SS ER Liability"
127: 14-Sep-2011 rosuri 12742758 115.39 Modified fnc_get_futa_credit_rate function
146: calculate the balance for all the assignments
147: for the person instead of current one assignment.
148: Modified the procedure prc_get_balance to change the
149: p_asg_type parameter passed to the procedure us_tax_balance
150: in the package pay_us_tax_bals_pkg from 'PER' to 'ASG' to
151: calculate the Assignment Level balance.
152: 02-SEP-2012 nvelaga 9796821 115.45 Modified the calculation of Medicare EE Tax based on new
153: limit and rate effective 2013.
154: 22-NOV-2012 nvelaga 15852506 115.57 Modified the calculation of new Medicate EE Tax Limit.
940: L_rval NUMBER := 0;
941:
942: BEGIN
943:
944: L_rval := pay_us_tax_bals_pkg.us_tax_balance
945: (IN_balance_type,
946: IN_tax_type,
947: IN_ee_or_er,
948: IN_dimension,
995: hr_utility.trace('IN_as_of_date'||IN_as_of_date);
996:
997: IF IN_mode = 'DATE' THEN
998:
999: L_rval := pay_us_tax_bals_pkg.us_tax_balance
1000: (IN_balance_type,
1001: IN_tax_type,
1002: IN_ee_or_er,
1003: IN_dimension,
3675: -- get ee balance for first 6 months
3676: BEGIN
3677: select assignment_id into l_assignment_id
3678: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* BUG# 10350917 */
3679: L_sui_ee_bal_first := pay_us_tax_bals_pkg.us_tax_balance
3680: ('TAXABLE',
3681: 'SUI',
3682: 'EE',
3683: 'YTD',
3750: -- get er balance for first 6 months
3751: BEGIN
3752: select assignment_id into l_assignment_id
3753: from pay_assignment_actions where assignment_action_id = L_asg_action_id; /* Bug 10350917 */
3754: L_sui_er_bal_first := pay_us_tax_bals_pkg.us_tax_balance
3755: ('TAXABLE',
3756: 'SUI',
3757: 'ER',
3758: 'YTD',