DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on HRUSERDT

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

1706: l_row_name := l_legal_employer_name || ' (' ||
1707: p_ctx_jurisdiction_code || ')';
1708:
1709:
1710: l_head_count := hruserdt.get_table_value(p_ctx_business_group_id,
1711: 'Employee Head Count',
1712: 'Number of Employees',
1713: l_row_name,
1714: p_ctx_effective_date);

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

2150:
2151: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
2152: /* Article 113, 114 and 115 */
2153:
2154: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2155: p_business_group_id
2156: ,p_isr_rates_table
2157: ,'Fixed Rate'
2158: ,TO_CHAR(ln_ISR_proj_subject)));

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

2158: ,TO_CHAR(ln_ISR_proj_subject)));
2159:
2160: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
2161:
2162: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2163: p_business_group_id
2164: ,p_isr_rates_table
2165: ,'Marginal Rate'
2166: ,TO_CHAR(ln_ISR_proj_subject)));

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

2166: ,TO_CHAR(ln_ISR_proj_subject)));
2167:
2168: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
2169:
2170: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2171: p_business_group_id
2172: ,p_isr_rates_table
2173: ,'Lower Bound'
2174: ,TO_CHAR(ln_ISR_proj_subject)));

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

2187: IF TO_CHAR(l_date_paid,'yyyymmdd')
2188: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
2189:
2190: /* Subsidy Calculation */
2191: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2192: p_business_group_id
2193: ,p_subsidy_table
2194: ,'Fixed Rate'
2195: ,TO_CHAR(ln_ISR_proj_subject)));

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

2195: ,TO_CHAR(ln_ISR_proj_subject)));
2196:
2197: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
2198:
2199: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2200: p_business_group_id
2201: ,p_subsidy_table
2202: ,'Marginal Rate'
2203: ,TO_CHAR(ln_ISR_proj_subject)));

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

2203: ,TO_CHAR(ln_ISR_proj_subject)));
2204:
2205: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
2206:
2207: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2208: p_business_group_id
2209: ,p_subsidy_table
2210: ,'Lower Bound'
2211: ,TO_CHAR(ln_ISR_proj_subject)));

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

2269: /*bug7445486 bug#8438155*/
2270: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142' AND l_compute_subsidy_flag <> 'N') THEN
2271:
2272: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
2273: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2274: p_business_group_id
2275: ,p_credit_to_salary_table
2276: ,'Amount'
2277: ,TO_CHAR(ln_ISR_proj_subject)));

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

2982:
2983: hr_utility_trace('Final Subject amount after proration: '||ln_ISR_proj_subject);
2984: /* Article 113, 114 and 115 */
2985:
2986: ln_fixed_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2987: p_business_group_id
2988: ,p_isr_rates_table
2989: ,'Fixed Rate'
2990: ,TO_CHAR(ln_ISR_proj_subject)));

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

2990: ,TO_CHAR(ln_ISR_proj_subject)));
2991:
2992: hr_utility_trace('ln_fixed_rate: '||ln_fixed_rate);
2993:
2994: ln_marginal_rate := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
2995: p_business_group_id
2996: ,p_isr_rates_table
2997: ,'Marginal Rate'
2998: ,TO_CHAR(ln_ISR_proj_subject)));

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

2998: ,TO_CHAR(ln_ISR_proj_subject)));
2999:
3000: hr_utility_trace('ln_marginal_rate: '||ln_marginal_rate);
3001:
3002: ln_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3003: p_business_group_id
3004: ,p_isr_rates_table
3005: ,'Lower Bound'
3006: ,TO_CHAR(ln_ISR_proj_subject)));

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

3019: IF TO_CHAR(l_date_paid,'yyyymmdd')
3020: < TO_CHAR(fnd_date.canonical_to_date('2008/01/01'),'yyyymmdd') THEN
3021:
3022: /* Subsidy Calculation */
3023: ln_fixed_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3024: p_business_group_id
3025: ,p_subsidy_table
3026: ,'Fixed Rate'
3027: ,TO_CHAR(ln_ISR_proj_subject)));

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

3027: ,TO_CHAR(ln_ISR_proj_subject)));
3028:
3029: hr_utility_trace('ln_fixed_subsidy: '||ln_fixed_subsidy);
3030:
3031: ln_marginal_subsidy := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3032: p_business_group_id
3033: ,p_subsidy_table
3034: ,'Marginal Rate'
3035: ,TO_CHAR(ln_ISR_proj_subject)));

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

3035: ,TO_CHAR(ln_ISR_proj_subject)));
3036:
3037: hr_utility_trace('ln_marginal_subsidy: '||ln_marginal_subsidy);
3038:
3039: ln_subsidy_lower_limit := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3040: p_business_group_id
3041: ,p_subsidy_table
3042: ,'Lower Bound'
3043: ,TO_CHAR(ln_ISR_proj_subject)));

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

3101: /*bug7445486 bug#8438155*/
3102: IF ( p_credit_to_salary_table <> 'NONE' and P_CALC_MODE <>'ARTICLE142' AND l_compute_subsidy_flag <> 'N') THEN
3103:
3104: hr_utility_trace('inside subsidy '||p_credit_to_salary_table|| ' --- '||TO_CHAR(ln_ISR_proj_subject));
3105: p_credit_to_salary := FND_NUMBER.canonical_to_number(hruserdt.get_table_value (
3106: p_business_group_id
3107: ,p_credit_to_salary_table
3108: ,'Amount'
3109: ,TO_CHAR(ln_ISR_proj_subject)));