APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on PAY_US_PAYROLL_UTILS

Line 68: pay_us_payroll_utils.get_parameter(

64: (cp_payroll_action_id in number) is
65: select effective_date,
66: start_date,
67: business_group_id,
68: pay_us_payroll_utils.get_parameter(
69: 'TRANSFER_STATE',
70: legislative_parameters) state_abbrev,
71: to_number(substr(legislative_parameters,
72: instr(legislative_parameters,

Line 900: pay_us_payroll_utils.populate_jit_information(

896: lv_adj_payroll_id := '%';
897: end if;
898:
899:
900: pay_us_payroll_utils.populate_jit_information(
901: p_effective_date => ld_adj_start_date
902: ,p_get_state => 'Y');
903:
904: ln_step := 2;

Line 976: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists);

972: exit;
973: end if;
974:
975: hr_utility.trace('SIT Exists = ' ||
976: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists);
977: hr_utility.trace('SDI ER Exists = ' ||
978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);
979: /* Create an action if the employee is in a state which does not
980: have SIT or SDI Er taxes or if the employee is in MA */

Line 978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);

974:
975: hr_utility.trace('SIT Exists = ' ||
976: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists);
977: hr_utility.trace('SDI ER Exists = ' ||
978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);
979: /* Create an action if the employee is in a state which does not
980: have SIT or SDI Er taxes or if the employee is in MA */
981: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
982: = 'N' or

Line 981: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists

977: hr_utility.trace('SDI ER Exists = ' ||
978: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit);
979: /* Create an action if the employee is in a state which does not
980: have SIT or SDI Er taxes or if the employee is in MA */
981: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
982: = 'N' or
983: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
984: is null or
985: lv_state_code = '22' then

Line 983: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit

979: /* Create an action if the employee is in a state which does not
980: have SIT or SDI Er taxes or if the employee is in MA */
981: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists
982: = 'N' or
983: pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
984: is null or
985: lv_state_code = '22' then
986: hr_utility.set_location(gv_package || lv_procedure_name, 50);
987: lv_adj_flag := 'Y';

Line 1304: pay_us_payroll_utils.populate_jit_information(

1300: /* Populate JIT information which is used when doing
1301: balance adjustment */
1302: ln_step := 5;
1303: hr_utility.set_location(gv_package || lv_procedure_name, 15);
1304: pay_us_payroll_utils.populate_jit_information(
1305: p_effective_date => ld_adj_start_date
1306: ,p_get_state => 'Y');
1307:
1308: ln_step := 8;

Line 1628: := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;

1624:
1625:
1626: if g_adj_state_code is null then
1627: lv_sit_exists
1628: := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sit_exists;
1629: else
1630: lv_sit_exists
1631: := pay_get_tax_exists_pkg.get_tax_exists (
1632: p_juri_code => lv_state_code

Line 1847: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit

1843: ln_bal_value := 0;
1844: ln_badj_bal_value := 0;
1845: lv_sub_jd_flag := 'N';
1846: lv_sub2_jd_flag := 'N';
1847: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
1848: is null then
1849: hr_utility.set_location(gv_package || lv_procedure_name, 210);
1850: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
1851: if pay_us_emp_baladj_cleanup.ltr_sdi_er_tax_bal.count > 0 then

Line 2050: ln_sdi_er_wage_limit := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;

2046:
2047: lv_sub_jd_flag := 'N';
2048: ln_badj_bal_value := 0;
2049: ln_redu_subj_bal_value := 0;
2050: ln_sdi_er_wage_limit := pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit;
2051: hr_utility.trace('SDI ER Wage Limit = ' || ln_sdi_er_wage_limit);
2052:
2053: open c_get_per_latest_action(ln_assignment_id
2054: ,ln_tax_unit_id);

Line 2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit

2055: fetch c_get_per_latest_action into ln_per_max_run_action_id;
2056: close c_get_per_latest_action;
2057: hr_utility.trace('ln_per_max_run_action_id = ' || ln_per_max_run_action_id);
2058:
2059: if pay_us_payroll_utils.ltr_state_tax_info(lv_state_code).sdi_er_limit
2060: is not null then
2061: hr_utility.set_location(gv_package || lv_procedure_name, 170);
2062: hr_utility.trace('Jurisdiction = ' || lv_jurisdiction);
2063: if pay_us_emp_baladj_cleanup.ltr_misc_er_tax_bal.count > 0 then