[Home] [Help]
1853: 1. Find DISPOSABLE INCOME
1854: Calculate DI balance for child support according to current
1855: earnings and subject rules (ie. implemented via taxability rules).
1856: 2. Calculate disposable income exemption according to:
1857: 2.1 Standard federal criteria, ie. % Weekly DI and factor of minwage
1858: unless override exemption percentage is entered through
1859: element entries. Then use override exemption percentage.
1860: 2.2 State specific legislation.
1861: 2.3 Calculate disposable income exemption resulting from dependents.
3116: v_work_sched_name,
3117: v_range_start,
3118: v_range_end);
3119:
3120: ELSE-- Hourly emp using Standard Hours on asg.
3121:
3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3118: v_range_end);
3119:
3120: ELSE-- Hourly emp using Standard Hours on asg.
3121:
3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');
3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,
3121:
3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');
3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,
3127: v_range_start,
3128: v_range_end,
3129: p_asg_std_freq);
3122: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3123:
3124:
3125: hr_utility.trace(' calling hr_us_ff_udfs.Standard_Hours_Worked');
3126: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked( p_asg_std_hrs,
3127: v_range_start,
3128: v_range_end,
3129: p_asg_std_freq);
3130:
3288: v_work_sched_name,
3289: v_range_start,
3290: v_range_end);
3291:
3292: ELSE-- Hourly emp using Standard Hours on asg.
3293:
3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3290: v_range_end);
3291:
3292: ELSE-- Hourly emp using Standard Hours on asg.
3293:
3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3297:
3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,
3292: ELSE-- Hourly emp using Standard Hours on asg.
3293:
3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3297:
3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,
3299: v_range_start,
3300: v_range_end,
3294: hr_utility.trace(' Hourly emp using Standard Hours on asg');
3295:
3296: hr_utility.trace('calling hr_us_ff_udfs.Standard_Hours_Worked');
3297:
3298: v_hrs_per_range := hr_us_ff_udfs.Standard_Hours_Worked(p_asg_std_hrs,
3299: v_range_start,
3300: v_range_end,
3301: p_asg_std_freq);
3302:
3299: v_range_start,
3300: v_range_end,
3301: p_asg_std_freq);
3302:
3303: hr_utility.trace('returned hr_us_ff_udfs.Standard_Hours_Worked');
3304: END IF;
3305:
3306:
3307: IF v_period_hours THEN
3438: /* Instead of directly calling hr_us_ff_udfs, introducing an internal
3439: (Private) Function Call to be used within pay_us_inv_ded_formulas.
3440: hr_us_ff_udfs.convert_period_type fails to convert 'weekly' figure
3441: to 'period' one and vica-versa in case 'Hours Calculation Type'
3442: is set to 'Standard' at Payroll definition level.
3443: Irrespective of Payroll level 'Hours Calculation Type',
3444: (Annualized or Standard) system should be able to convert
3445: weekly to period figure correctly and vice-versa.
3446: */
3440: hr_us_ff_udfs.convert_period_type fails to convert 'weekly' figure
3441: to 'period' one and vica-versa in case 'Hours Calculation Type'
3442: is set to 'Standard' at Payroll definition level.
3443: Irrespective of Payroll level 'Hours Calculation Type',
3444: (Annualized or Standard) system should be able to convert
3445: weekly to period figure correctly and vice-versa.
3446: */
3447: /*
3448: RETURN (hr_us_ff_udfs.convert_period_type(CTX_BUSINESS_GROUP_ID,
5978: c_fed_levy_xmpt_tab_col varchar2(100);
5979: c_fed_levy_xmpt_per_xmpt_row varchar2(100);
5980: c_federal_minimum_wage number;
5981: take_home_pay number;
5982: standard_deduction pay_user_column_instances_f.value%TYPE;
5983: allowance_per_exemption pay_user_column_instances_f.value%TYPE;
5984: personal_exemption_allowance number;
5985: fed_levy_annual_exemption number;
5986: fed_levy_exemption number;
6125: /*
6126: Algorithm: Federal Tax Levies are calculated according to the following:
6127: 1. Calculate Take Home Pay which equals gross earnings less taxes and deductions in
6128: effect prior to the date of levy.
6129: 2. Calculate Fed levy exemption as the employees standard deduction for fed
6130: income tax purposes; plus the personal exemption allowance.
6131: Convert this annual figure to the payroll period type of the employee.
6132: 3. The difference between Take Home Pay and the fed levy exemption is the
6133: amount to withhold - ie. everything!
6131: Convert this annual figure to the payroll period type of the employee.
6132: 3. The difference between Take Home Pay and the fed levy exemption is the
6133: amount to withhold - ie. everything!
6134:
6135: NOTE: The filing status and allowances to be used to compute standard and
6136: personal exemption MUST BE ENTERED, we will not use W-4 for this info.
6137:
6138: */
6139:
6185: calc_subprio := sub_prio_max - (PAY_EARNED_END_DATE - Date_Served);
6186: END IF;
6187: END IF;
6188:
6189: c_Fed_Levy_Exemption_Table := 'Federal Tax Standard Deduction Table';
6190: c_fed_levy_xmpt_tab_col := 'Exemption Amount';
6191: c_fed_levy_xmpt_per_xmpt_row := 'Personal Exemption';
6192:
6193: -- 5111601
6213: Dedns_at_Time_of_Writ;
6214:
6215: /* *** Step #2 *** */
6216:
6217: standard_deduction := get_table_value(c_Fed_Levy_Exemption_Table,
6218: c_fed_levy_xmpt_tab_col,
6219: Filing_Status,
6220: ld_filing_status_date);
6221:
6225: ld_filing_status_date);
6226:
6227: hr_utility.trace('Year of Exemption '|| to_char(ld_filing_status_date,
6228: 'DD-MON-YYYY'));
6229: hr_utility.trace('Exemption Amount '|| standard_deduction);
6230: hr_utility.trace('Personal Exemption '|| allowance_per_exemption);
6231:
6232:
6233: personal_exemption_allowance := TO_NUMBER(allowance_per_exemption) * Allowances;
6273: exemption_for_age_65_or_blind := 0 ;
6274: END IF ;
6275: hr_utility.trace('Exemption Amount for Age >= 65 or Blind '||to_char(exemption_for_age_65_or_blind)) ;
6276:
6277: fed_levy_annual_exemption := TO_NUMBER(standard_deduction) +
6278: personal_exemption_allowance +
6279: exemption_for_age_65_or_blind ;
6280:
6281: hr_utility.trace('Federal Levy Annual Exemption '||to_char(fed_levy_annual_exemption)) ;