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

Line 1: PACKAGE BODY pay_us_payroll_utils AS

1: PACKAGE BODY pay_us_payroll_utils AS
2: /* $Header: pyusutil.pkb 120.2.12020000.2 2012/07/05 03:56:05 amnaraya ship $ */
3: /*
4: ******************************************************************
5: * *

Line 20: Name : pay_us_payroll_utils

16: * 500 Oracle Parkway, Redwood City, CA, 94065. *
17: * *
18: ******************************************************************
19:
20: Name : pay_us_payroll_utils
21:
22: Description : The package has all the common packages used in
23: US Payroll.
24:

Line 140: gv_package VARCHAR2(100) := 'pay_us_payroll_utils';

136:
137: /*****************************************************************************
138: ** Package Local Variables
139: *****************************************************************************/
140: gv_package VARCHAR2(100) := 'pay_us_payroll_utils';
141: gc_csv_delimiter VARCHAR2(1) := ',';
142: gc_csv_data_delimiter VARCHAR2(1) := '"';
143:
144: gv_html_start_data VARCHAR2(5) := '' ;

Line 284: pay_us_payroll_utils.ltr_fed_tax_info.count < 1 then

280: /***************************************************************
281: ** Build a PL/SQL table which has federal tax info
282: ***************************************************************/
283: if p_get_federal = 'Y' and
284: pay_us_payroll_utils.ltr_fed_tax_info.count < 1 then
285: ln_step := 5;
286: open c_get_federal_jit (p_effective_date, '401K LIMITS');
287: fetch c_get_federal_jit into ln_futa_wage, ln_futa_rate,
288: ln_ss_ee_wage, ln_ss_ee_rate,

Line 307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;

303: p_effective_date => p_effective_date,
304: p_limit => '457 ADDITIONAL CATCHUP');
305: ln_dcp_limit := pqp_us_srs_extracts.get_dcp_limit(p_effective_date);
306:
307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;
308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;

Line 308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;

304: p_limit => '457 ADDITIONAL CATCHUP');
305: ln_dcp_limit := pqp_us_srs_extracts.get_dcp_limit(p_effective_date);
306:
307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;
308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;

Line 309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;

305: ln_dcp_limit := pqp_us_srs_extracts.get_dcp_limit(p_effective_date);
306:
307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;
308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;

Line 310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;

306:
307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;
308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;

Line 311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;

307: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage := ln_futa_wage;
308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;

Line 312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;

308: pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate := ln_futa_rate;
309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;

Line 313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;

309: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage := ln_ss_ee_wage;
310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;

Line 314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;

310: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate := ln_ss_ee_rate;
311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;

Line 315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;

311: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage := ln_ss_er_wage;
312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;

Line 316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;

312: pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate := ln_ss_er_rate;
313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;

Line 317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;

313: pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate := ln_medi_ee_rate;
314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;
321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;

Line 318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;

314: pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate := ln_medi_er_rate;
315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;
321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;
322: end if;

Line 319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;

315: pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit := ln_401k;
316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;
321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;
322: end if;
323:

Line 320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;

316: pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit := ln_403b;
317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;
321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;
322: end if;
323:
324: /***************************************************************

Line 321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;

317: pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit := ln_457;
318: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k := ln_401k_catchup;
319: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b := ln_403_catchup;
320: pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457 := ln_457_catchup;
321: pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit := ln_dcp_limit;
322: end if;
323:
324: /***************************************************************
325: ** Build a PL/SQL table which has state tax info for all states

Line 330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);

326: ***************************************************************/
327: hr_utility.set_location(gv_package || lv_procedure_name, 300);
328: ln_step := 10;
329: hr_utility.set_location(p_get_state,310);
330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
331: if p_get_state = 'Y' and
332: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
333: open c_get_states_jit(p_effective_date);
334: loop

Line 332: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then

328: ln_step := 10;
329: hr_utility.set_location(p_get_state,310);
330: hr_utility.set_location(to_char( pay_us_payroll_utils.ltr_state_tax_info.count),320);
331: if p_get_state = 'Y' and
332: pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
333: open c_get_states_jit(p_effective_date);
334: loop
335: fetch c_get_states_jit into lv_state_code, lv_sit_exists,
336: ln_sui_ee_limit, ln_sui_er_limit ,

Line 355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists

351: hr_utility.trace('ln_sdi_er_limit = ' || ln_sdi_er_limit);
352: hr_utility.trace('lv_steic_exists = ' || lv_steic_exists);
353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:
355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
356: := lv_sit_exists;
357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit
358: := ln_sui_ee_limit;
359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit

Line 357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit

353: hr_utility.trace('ln_state_futa_rate= '|| ln_state_futa_rate);
354:
355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
356: := lv_sit_exists;
357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit
358: := ln_sui_ee_limit;
359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit
360: := ln_sui_er_limit;
361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit

Line 359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit

355: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
356: := lv_sit_exists;
357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit
358: := ln_sui_ee_limit;
359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit
360: := ln_sui_er_limit;
361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit
362: := ln_sdi_ee_limit;
363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit

Line 361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit

357: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit
358: := ln_sui_ee_limit;
359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit
360: := ln_sui_er_limit;
361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit
362: := ln_sdi_ee_limit;
363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
364: := ln_sdi_er_limit;
365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists

Line 363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit

359: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit
360: := ln_sui_er_limit;
361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit
362: := ln_sdi_ee_limit;
363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
364: := ln_sdi_er_limit;
365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists
366: := lv_steic_exists;
367: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate

Line 365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists

361: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit
362: := ln_sdi_ee_limit;
363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
364: := ln_sdi_er_limit;
365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists
366: := lv_steic_exists;
367: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate
368: := ln_state_futa_rate;
369: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit

Line 367: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate

363: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
364: := ln_sdi_er_limit;
365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists
366: := lv_steic_exists;
367: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate
368: := ln_state_futa_rate;
369: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit
370: := ln_sdi1_ee_limit;
371:

Line 369: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit

365: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists
366: := lv_steic_exists;
367: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate
368: := ln_state_futa_rate;
369: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit
370: := ln_sdi1_ee_limit;
371:
372: end loop;
373: close c_get_states_jit;

Line 379: pay_us_payroll_utils.ltr_county_tax_info.count < 1 then

375: hr_utility.set_location(gv_package || lv_procedure_name, 350);
376:
377: ln_step := 55;
378: if p_get_county = 'Y' and
379: pay_us_payroll_utils.ltr_county_tax_info.count < 1 then
380: open c_get_county_jit(p_effective_date);
381: loop
382: fetch c_get_county_jit into lv_jurisdiction_code,
383: lv_county_tax_exists,

Line 402: pay_us_payroll_utils.ltr_county_tax_info(ln_index).jurisdiction_code

398: ln_index := to_number(lv_temp_code);
399:
400: /********************* End ****************************************************/
401:
402: pay_us_payroll_utils.ltr_county_tax_info(ln_index).jurisdiction_code
403: := lv_jurisdiction_code;
404: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_tax_exists
405: := lv_county_tax_exists;
406: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_head_tax_exists

Line 404: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_tax_exists

400: /********************* End ****************************************************/
401:
402: pay_us_payroll_utils.ltr_county_tax_info(ln_index).jurisdiction_code
403: := lv_jurisdiction_code;
404: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_tax_exists
405: := lv_county_tax_exists;
406: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_head_tax_exists
407: := lv_county_head_tax_exists;
408: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

Line 406: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_head_tax_exists

402: pay_us_payroll_utils.ltr_county_tax_info(ln_index).jurisdiction_code
403: := lv_jurisdiction_code;
404: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_tax_exists
405: := lv_county_tax_exists;
406: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_head_tax_exists
407: := lv_county_head_tax_exists;
408: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
409: := lv_county_sd_tax_exists;
410:

Line 408: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_sd_tax_exists

404: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_tax_exists
405: := lv_county_tax_exists;
406: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_head_tax_exists
407: := lv_county_head_tax_exists;
408: pay_us_payroll_utils.ltr_county_tax_info(ln_index).cnty_sd_tax_exists
409: := lv_county_sd_tax_exists;
410:
411: end loop;
412: close c_get_county_jit;

Line 439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code

435: lv_city_head_tax_exists,
436: lv_city_sd_tax_exists;
437: if c_get_city_jit%notfound then
438: hr_utility.set_location(gv_package || lv_procedure_name, 460);
439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := p_jurisdiction_code;
441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
442: := NULL;
443: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists

Line 441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists

437: if c_get_city_jit%notfound then
438: hr_utility.set_location(gv_package || lv_procedure_name, 460);
439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := p_jurisdiction_code;
441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
442: := NULL;
443: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
444: := NULL;
445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists

Line 443: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists

439: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
440: := p_jurisdiction_code;
441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
442: := NULL;
443: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
444: := NULL;
445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
446: := NULL;
447: else

Line 445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists

441: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
442: := NULL;
443: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
444: := NULL;
445: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
446: := NULL;
447: else
448: hr_utility.set_location(gv_package || lv_procedure_name, 470);
449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);

Line 451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code

447: else
448: hr_utility.set_location(gv_package || lv_procedure_name, 470);
449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
450:
451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
452: := lv_city_jurisdiction_code;
453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
454: := lv_city_tax_exists;
455: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists

Line 453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists

449: hr_utility.trace('lv_jurisdiction_code = ' || lv_city_jurisdiction_code);
450:
451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
452: := lv_city_jurisdiction_code;
453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
454: := lv_city_tax_exists;
455: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
456: := lv_city_head_tax_exists;
457: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists

Line 455: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists

451: pay_us_payroll_utils.ltr_city_tax_info(ln_index).jurisdiction_code
452: := lv_city_jurisdiction_code;
453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
454: := lv_city_tax_exists;
455: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
456: := lv_city_head_tax_exists;
457: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
458: := lv_city_sd_tax_exists;
459: end if;

Line 457: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists

453: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_tax_exists
454: := lv_city_tax_exists;
455: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_head_tax_exists
456: := lv_city_head_tax_exists;
457: pay_us_payroll_utils.ltr_city_tax_info(ln_index).city_sd_tax_exists
458: := lv_city_sd_tax_exists;
459: end if;
460:
461: close c_get_city_jit;

Line 563: if pay_us_payroll_utils.ltr_fed_tax_info.count < 1 then

559:
560: --federal
561: if p_jurisdiction_code = '00-000-0000' then
562:
563: if pay_us_payroll_utils.ltr_fed_tax_info.count < 1 then
564: populate_jit_information( p_effective_date => p_effective_date
565: , p_get_federal => 'Y');
566: end if;
567:

Line 569: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;

565: , p_get_federal => 'Y');
566: end if;
567:
568: if p_tax_type = 'FUTA WAGE' then
569: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
570: elsif p_tax_type = 'FUTA RATE' then
571: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate;
572: elsif p_tax_type = 'SS EE' then
573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

Line 571: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate;

567:
568: if p_tax_type = 'FUTA WAGE' then
569: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
570: elsif p_tax_type = 'FUTA RATE' then
571: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate;
572: elsif p_tax_type = 'SS EE' then
573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
574: elsif p_tax_type = 'SS EE RATE' then
575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;

Line 573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;

569: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_wage;
570: elsif p_tax_type = 'FUTA RATE' then
571: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate;
572: elsif p_tax_type = 'SS EE' then
573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
574: elsif p_tax_type = 'SS EE RATE' then
575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
576: elsif p_tax_type = 'SS ER' then
577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;

Line 575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;

571: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).futa_rate;
572: elsif p_tax_type = 'SS EE' then
573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
574: elsif p_tax_type = 'SS EE RATE' then
575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
576: elsif p_tax_type = 'SS ER' then
577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
578: elsif p_tax_type = 'SS ER RATE' then
579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;

Line 577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;

573: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_wage;
574: elsif p_tax_type = 'SS EE RATE' then
575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
576: elsif p_tax_type = 'SS ER' then
577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
578: elsif p_tax_type = 'SS ER RATE' then
579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
580: elsif p_tax_type = 'MED EE RATE' then
581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;

Line 579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;

575: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_ee_rate;
576: elsif p_tax_type = 'SS ER' then
577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
578: elsif p_tax_type = 'SS ER RATE' then
579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
580: elsif p_tax_type = 'MED EE RATE' then
581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
582: elsif p_tax_type = 'MED ER RATE' then
583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;

Line 581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;

577: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_wage;
578: elsif p_tax_type = 'SS ER RATE' then
579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
580: elsif p_tax_type = 'MED EE RATE' then
581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
582: elsif p_tax_type = 'MED ER RATE' then
583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
584: elsif p_tax_type = '401K' then
585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;

Line 583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;

579: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).ss_er_rate;
580: elsif p_tax_type = 'MED EE RATE' then
581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
582: elsif p_tax_type = 'MED ER RATE' then
583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
584: elsif p_tax_type = '401K' then
585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
586: elsif p_tax_type = '403B' then
587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;

Line 585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;

581: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_ee_rate;
582: elsif p_tax_type = 'MED ER RATE' then
583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
584: elsif p_tax_type = '401K' then
585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
586: elsif p_tax_type = '403B' then
587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
588: elsif p_tax_type = '457' then
589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;

Line 587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;

583: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).med_er_rate;
584: elsif p_tax_type = '401K' then
585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
586: elsif p_tax_type = '403B' then
587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
588: elsif p_tax_type = '457' then
589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
590: elsif p_tax_type = '401K CATCHUP' then
591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;

Line 589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;

585: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p401_limit;
586: elsif p_tax_type = '403B' then
587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
588: elsif p_tax_type = '457' then
589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
590: elsif p_tax_type = '401K CATCHUP' then
591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
592: elsif p_tax_type = '403B CATCHUP' then
593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;

Line 591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;

587: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p403_limit;
588: elsif p_tax_type = '457' then
589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
590: elsif p_tax_type = '401K CATCHUP' then
591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
592: elsif p_tax_type = '403B CATCHUP' then
593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
594: elsif p_tax_type = '457 CATCHUP' then
595: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;

Line 593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;

589: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).p457_limit;
590: elsif p_tax_type = '401K CATCHUP' then
591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
592: elsif p_tax_type = '403B CATCHUP' then
593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
594: elsif p_tax_type = '457 CATCHUP' then
595: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
596: elsif p_tax_type = 'DCP' then
597: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;

Line 595: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;

591: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_401k;
592: elsif p_tax_type = '403B CATCHUP' then
593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
594: elsif p_tax_type = '457 CATCHUP' then
595: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
596: elsif p_tax_type = 'DCP' then
597: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
598: end if;
599:

Line 597: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;

593: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_403b;
594: elsif p_tax_type = '457 CATCHUP' then
595: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).catchup_457;
596: elsif p_tax_type = 'DCP' then
597: lv_value := pay_us_payroll_utils.ltr_fed_tax_info(1).dcp_limit;
598: end if;
599:
600: --state
601: elsif lv_state_code <> '00' and

Line 605: if pay_us_payroll_utils.ltr_state_tax_info.count < 1 then

601: elsif lv_state_code <> '00' and
602: lv_county_code = '000' and
603: lv_city_code = '0000' then
604:
605: if pay_us_payroll_utils.ltr_state_tax_info.count < 1 then
606: populate_jit_information(p_effective_date => p_effective_date
607: ,p_get_state => 'Y');
608: end if;
609:

Line 611: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit;

607: ,p_get_state => 'Y');
608: end if;
609:
610: if p_tax_type = 'SUI EE' then
611: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit;
612: elsif p_tax_type = 'SUI ER' then
613: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;
614: hr_utility.set_location(lv_value,230);
615: elsif p_tax_type = 'SDI EE' then

Line 613: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;

609:
610: if p_tax_type = 'SUI EE' then
611: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_ee_limit;
612: elsif p_tax_type = 'SUI ER' then
613: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;
614: hr_utility.set_location(lv_value,230);
615: elsif p_tax_type = 'SDI EE' then
616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
617: elsif p_tax_type = 'SDI1 EE' then

Line 616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;

612: elsif p_tax_type = 'SUI ER' then
613: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sui_er_limit;
614: hr_utility.set_location(lv_value,230);
615: elsif p_tax_type = 'SDI EE' then
616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
617: elsif p_tax_type = 'SDI1 EE' then
618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;
619: elsif p_tax_type = 'SDI ER' then
620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;

Line 618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;

614: hr_utility.set_location(lv_value,230);
615: elsif p_tax_type = 'SDI EE' then
616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
617: elsif p_tax_type = 'SDI1 EE' then
618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;
619: elsif p_tax_type = 'SDI ER' then
620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
621: elsif p_tax_type = 'SIT EE' then
622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;

Line 620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;

616: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_ee_limit;
617: elsif p_tax_type = 'SDI1 EE' then
618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;
619: elsif p_tax_type = 'SDI ER' then
620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
621: elsif p_tax_type = 'SIT EE' then
622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;
623: elsif p_tax_type = 'STEIC EE' then
624: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists;

Line 622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;

618: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi1_ee_limit;
619: elsif p_tax_type = 'SDI ER' then
620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
621: elsif p_tax_type = 'SIT EE' then
622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;
623: elsif p_tax_type = 'STEIC EE' then
624: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists;
625: elsif p_tax_type = 'FUTA ER' then
626: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate;

Line 624: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists;

620: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
621: elsif p_tax_type = 'SIT EE' then
622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;
623: elsif p_tax_type = 'STEIC EE' then
624: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists;
625: elsif p_tax_type = 'FUTA ER' then
626: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate;
627: elsif p_tax_type = 'FUTA ' then
628: lv_value := 'Y'; -- Bug3969061

Line 626: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate;

622: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;
623: elsif p_tax_type = 'STEIC EE' then
624: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).steic_exists;
625: elsif p_tax_type = 'FUTA ER' then
626: lv_value := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).futa_rate;
627: elsif p_tax_type = 'FUTA ' then
628: lv_value := 'Y'; -- Bug3969061
629: elsif p_tax_type in ('WC EE', 'WC2 EE') then
630: begin

Line 652: if pay_us_payroll_utils.ltr_county_tax_info.count<1 then

648: elsif lv_state_code <> '00' and
649: lv_county_code <> '000' and
650: lv_city_code = '0000' then
651:
652: if pay_us_payroll_utils.ltr_county_tax_info.count<1 then
653: populate_jit_information(p_effective_date => p_effective_date
654: ,p_get_county => 'Y');
655: end if;
656:

Line 660: if pay_us_payroll_utils.ltr_county_tax_info.exists(ln_index_code) then

656:
657: lv_temp_code := lv_state_code||lv_county_code;
658: ln_index_code := to_number(lv_temp_code);
659:
660: if pay_us_payroll_utils.ltr_county_tax_info.exists(ln_index_code) then
661: lv_value := pay_us_payroll_utils.ltr_county_tax_info(ln_index_code).cnty_tax_exists;
662: end if;
663:
664: --city

Line 661: lv_value := pay_us_payroll_utils.ltr_county_tax_info(ln_index_code).cnty_tax_exists;

657: lv_temp_code := lv_state_code||lv_county_code;
658: ln_index_code := to_number(lv_temp_code);
659:
660: if pay_us_payroll_utils.ltr_county_tax_info.exists(ln_index_code) then
661: lv_value := pay_us_payroll_utils.ltr_county_tax_info(ln_index_code).cnty_tax_exists;
662: end if;
663:
664: --city
665: elsif lv_state_code <> '00' and

Line 674: if pay_us_payroll_utils.ltr_city_tax_info.count < 1 then

670: /* for user defined cities we should return N because they are not
671: primary cities and will never have tax */
672: lv_value := 'N';
673: else
674: if pay_us_payroll_utils.ltr_city_tax_info.count < 1 then
675: populate_jit_information(p_effective_date => p_effective_date
676: ,p_get_city => 'Y'
677: ,p_jurisdiction_code => p_jurisdiction_code);
678: end if;

Line 687: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then

683: ln_index_code := to_number(lv_temp_code);
684: hr_utility.trace(' A4 ln_index_code');
685:
686: if p_tax_type = 'CITY' then
687: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
688:
689: hr_utility.trace(' CITY found in PLSQL table');
690: null;
691: else

Line 699: := pay_us_payroll_utils.ltr_city_tax_info(ln_index_code).city_tax_exists;

695: ,p_get_city => 'Y'
696: ,p_jurisdiction_code => p_jurisdiction_code);
697: end if;
698: lv_value
699: := pay_us_payroll_utils.ltr_city_tax_info(ln_index_code).city_tax_exists;
700: end if;
701:
702: if p_tax_type = 'HT' then
703: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then

Line 703: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then

699: := pay_us_payroll_utils.ltr_city_tax_info(ln_index_code).city_tax_exists;
700: end if;
701:
702: if p_tax_type = 'HT' then
703: if pay_us_payroll_utils.ltr_city_tax_info.exists(ln_index_code) then
704: hr_utility.trace(' HT found in PLSQL table');
705: null;
706: else
707: hr_utility.trace(' HT NOT found in PLSQL table');

Line 712: lv_value := pay_us_payroll_utils.ltr_city_tax_info(ln_index_code).city_head_tax_exists;

708: populate_jit_information(p_effective_date => p_effective_date
709: ,p_get_city => 'Y'
710: ,p_jurisdiction_code => p_jurisdiction_code);
711: end if;
712: lv_value := pay_us_payroll_utils.ltr_city_tax_info(ln_index_code).city_head_tax_exists;
713: end if;
714:
715: /********************* Bug Number:2973119 End ****************************/
716:

Line 799: lv_package_stage VARCHAR2(50) := 'pay_us_payroll_utils.check_balance_status';

795:
796: ln_attribute_exists NUMBER(1);
797: ln_valid_bal_exists NUMBER(1);
798: lv_return_status VARCHAR2(1) := 'N';
799: lv_package_stage VARCHAR2(50) := 'pay_us_payroll_utils.check_balance_status';
800:
801: l_attribute_count number;
802: l_valid_count number;
803: l_trunc_date date; /* Bug 3258868 */

Line 1316: END pay_us_payroll_utils;

1312: raise_application_error(-20101, 'Error while updating the Link');
1313: raise;
1314: END update_state_or_local_wh_link;
1315:
1316: END pay_us_payroll_utils;