APPS.PAY_US_INV_DED_FORMULAS dependencies on STANDARD

Line 1727: 2.1 Standard federal criteria, ie. % Weekly DI and factor of minwage

1723: 1. Find DISPOSABLE INCOME
1724: Calculate DI balance for child support according to current
1725: earnings and subject rules (ie. implemented via taxability rules).
1726: 2. Calculate disposable income exemption according to:
1727: 2.1 Standard federal criteria, ie. % Weekly DI and factor of minwage
1728: unless override exemption percentage is entered through
1729: element entries. Then use override exemption percentage.
1730: 2.2 State specific legislation.
1731: 2.3 Calculate disposable income exemption resulting from dependents.

Line 5116: standard_deduction pay_user_column_instances_f.value%TYPE;

5112: c_fed_levy_xmpt_tab_col varchar2(100);
5113: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5114: c_federal_minimum_wage number;
5115: take_home_pay number;
5116: standard_deduction pay_user_column_instances_f.value%TYPE;
5117: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5118: personal_exemption_allowance number;
5119: fed_levy_annual_exemption number;
5120: fed_levy_exemption number;

Line 5263: 2. Calculate Fed levy exemption as the employees standard deduction for fed

5259: /*
5260: Algorithm: Federal Tax Levies are calculated according to the following:
5261: 1. Calculate Take Home Pay which equals gross earnings less taxes and deductions in
5262: effect prior to the date of levy.
5263: 2. Calculate Fed levy exemption as the employees standard deduction for fed
5264: income tax purposes; plus the personal exemption allowance.
5265: Convert this annual figure to the payroll period type of the employee.
5266: 3. The difference between Take Home Pay and the fed levy exemption is the
5267: amount to withhold - ie. everything!

Line 5269: NOTE: The filing status and allowances to be used to compute standard and

5265: Convert this annual figure to the payroll period type of the employee.
5266: 3. The difference between Take Home Pay and the fed levy exemption is the
5267: amount to withhold - ie. everything!
5268:
5269: NOTE: The filing status and allowances to be used to compute standard and
5270: personal exemption MUST BE ENTERED, we will not use W-4 for this info.
5271:
5272: */
5273:

Line 5323: c_Fed_Levy_Exemption_Table := 'Federal Tax Standard Deduction Table';

5319: calc_subprio := sub_prio_max - (PAY_EARNED_END_DATE - Date_Served);
5320: END IF;
5321: END IF;
5322:
5323: c_Fed_Levy_Exemption_Table := 'Federal Tax Standard Deduction Table';
5324: c_fed_levy_xmpt_tab_col := 'Exemption Amount';
5325: c_fed_levy_xmpt_per_xmpt_row := 'Personal Exemption';
5326:
5327: -- 5111601

Line 5351: standard_deduction := get_table_value(c_Fed_Levy_Exemption_Table,

5347: Dedns_at_Time_of_Writ;
5348:
5349: /* *** Step #2 *** */
5350:
5351: standard_deduction := get_table_value(c_Fed_Levy_Exemption_Table,
5352: c_fed_levy_xmpt_tab_col,
5353: Filing_Status,
5354: ld_filing_status_date);
5355:

Line 5363: hr_utility.trace('Exemption Amount '|| standard_deduction);

5359: ld_filing_status_date);
5360:
5361: hr_utility.trace('Year of Exemption '|| to_char(ld_filing_status_date,
5362: 'DD-MON-YYYY'));
5363: hr_utility.trace('Exemption Amount '|| standard_deduction);
5364: hr_utility.trace('Personal Exemption '|| allowance_per_exemption);
5365:
5366:
5367: personal_exemption_allowance := TO_NUMBER(allowance_per_exemption) * Allowances;

Line 5411: fed_levy_annual_exemption := TO_NUMBER(standard_deduction) +

5407: exemption_for_age_65_or_blind := 0 ;
5408: END IF ;
5409: hr_utility.trace('Exemption Amount for Age >= 65 or Blind '||to_char(exemption_for_age_65_or_blind)) ;
5410:
5411: fed_levy_annual_exemption := TO_NUMBER(standard_deduction) +
5412: personal_exemption_allowance +
5413: exemption_for_age_65_or_blind ;
5414:
5415: hr_utility.trace('Federal Levy Annual Exemption '||to_char(fed_levy_annual_exemption)) ;