APPS.PAY_MX_TAX_FUNCTIONS dependencies on HRUSERDT

Line 1576: l_head_count := hruserdt.get_table_value(p_ctx_business_group_id,

1572: l_row_name := l_legal_employer_name || ' (' ||
1573: p_ctx_jurisdiction_code || ')';
1574:
1575:
1576: l_head_count := hruserdt.get_table_value(p_ctx_business_group_id,
1577: 'Employee Head Count',
1578: 'Number of Employees',
1579: l_row_name,
1580: p_ctx_effective_date);

Line 1986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

1982:
1983: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
1984: /* Article 113, 114 and 115 */
1985:
1986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
1987: p_business_group_id
1988: ,p_isr_rates_table
1989: ,'Fixed Rate'
1990: ,TO_CHAR(ln_ISR_proj_subject)));

Line 1994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

1990: ,TO_CHAR(ln_ISR_proj_subject)));
1991:
1992: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
1993:
1994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
1995: p_business_group_id
1996: ,p_isr_rates_table
1997: ,'Marginal Rate'
1998: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

1998: ,TO_CHAR(ln_ISR_proj_subject)));
1999:
2000: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
2001:
2002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2003: p_business_group_id
2004: ,p_isr_rates_table
2005: ,'Lower Bound'
2006: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2019: IF TO_CHAR(l_date_paid,'yyyymmdd')
2020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2021:
2022: /* Subsidy Calculation */
2023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2024: p_business_group_id
2025: ,p_subsidy_table
2026: ,'Fixed Rate'
2027: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2027: ,TO_CHAR(ln_ISR_proj_subject)));
2028:
2029: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
2030:
2031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2032: p_business_group_id
2033: ,p_subsidy_table
2034: ,'Marginal Rate'
2035: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2035: ,TO_CHAR(ln_ISR_proj_subject)));
2036:
2037: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
2038:
2039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2040: p_business_group_id
2041: ,p_subsidy_table
2042: ,'Lower Bound'
2043: ,TO_CHAR(ln_ISR_proj_subject)));

Line 2095: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (

2091:
2092: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142') THEN /*bug7445486*/
2093:
2094: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
2095: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2096: p_business_group_id
2097: ,p_credit_to_salary_table
2098: ,'Amount'
2099: ,TO_CHAR(ln_ISR_proj_subject)));