APPS.PAY_MX_TAX_FUNCTIONS dependencies on HR_MX_UTILITY

Line 33: 21-JAN-2005 ardsouza 115.3 4129001 hr_mx_utility.get_gre_from_location

29: 23-SEP-2004 sdahiya 115.0 Created.
30: 29-OCT-2004 sdahiya 115.1 Extended support for partially
31: subject earnings.
32: 09-NOV-2004 sdahiya 115.2 Added GET_SS_QUOTA_INFO function
33: 21-JAN-2005 ardsouza 115.3 4129001 hr_mx_utility.get_gre_from_location
34: call modified to pass BG.
35: 21-FEB-2005 sdahiya 115.4 - Modified get_previous_period_bal
36: to fetch values for any defined
37: balance passed.

Line 385: l_gre_id := hr_mx_utility.get_gre_from_scl (l_scl_id);

381: CLOSE csr_get_asg_info;
382:
383: END IF;
384:
385: l_gre_id := hr_mx_utility.get_gre_from_scl (l_scl_id);
386:
387: hr_utility_trace('GRE obtained from SCL = "'||l_gre_id||'"');
388:
389: IF l_gre_id is null THEN

Line 390: l_gre_id := hr_mx_utility.get_gre_from_location(

386:
387: hr_utility_trace('GRE obtained from SCL = "'||l_gre_id||'"');
388:
389: IF l_gre_id is null THEN
390: l_gre_id := hr_mx_utility.get_gre_from_location(
391: l_location_id,
392: l_business_group_id, -- Bug 4129001
393: l_effective_date,
394: l_is_ambiguous,

Line 1252: l_service_years := hr_mx_utility.get_seniority(

1248: );
1249:
1250: ELSIF l_calc_rule = 'SINGLE_RANGE_SENIORITY_ANNUAL' THEN
1251:
1252: l_service_years := hr_mx_utility.get_seniority(
1253: p_business_group_id => p_ctx_business_group_id
1254: ,p_tax_unit_id => l_tax_unit_id
1255: ,p_payroll_id => l_payroll_id
1256: ,p_person_id => ln_person_id

Line 1621: hr_mx_utility.get_wrip (

1617: /* Override values fetched by this cursor
1618: IF p_legislation_info_type = 'MX Social Security Information' THEN
1619: IF p_legislation_info1 = 'WRI' THEN
1620: g_pay_mx_legislation_info_f(cntr).legislation_info5 :=
1621: hr_mx_utility.get_wrip (
1622: p_business_group_id => p_ctx_business_group_id,
1623: p_tax_unit_id => p_ctx_tax_unit_id);
1624: END IF;
1625: END IF;*/

Line 1654: hr_mx_utility.get_wrip (

1650: p_legislation_info5,
1651: p_legislation_info6;
1652: CLOSE csr_get_ss_info;
1653: p_legislation_info5 :=
1654: hr_mx_utility.get_wrip (
1655: p_business_group_id => p_ctx_business_group_id,
1656: p_tax_unit_id => p_ctx_tax_unit_id);
1657: END IF;
1658: END IF;

Line 1699: hr_mx_utility.get_legal_employer(

1695:
1696: hr_utility_trace('Entering ' || l_proc_name);
1697:
1698: l_legal_employer_name := hr_general.decode_organization(
1699: hr_mx_utility.get_legal_employer(
1700: p_ctx_business_group_id,
1701: p_ctx_tax_unit_id)
1702: );
1703:

Line 1761: l_legal_er_id := hr_mx_utility.get_legal_employer(p_ctx_business_group_id,

1757: l_proc_name := g_proc_name || 'GET_MX_STATE_TAX_RULES';
1758:
1759: hr_utility_trace('Entering ' || l_proc_name);
1760:
1761: l_legal_er_id := hr_mx_utility.get_legal_employer(p_ctx_business_group_id,
1762: p_ctx_tax_unit_id);
1763:
1764: OPEN c_get_rate_data(l_legal_er_id);
1765: FETCH c_get_rate_data INTO l_return_value;

Line 2091: ln_le_id := hr_mx_utility.get_legal_employer(

2087: hr_utility_trace('Number of days in the pay period : '||ln_days_in_a_period);
2088:
2089: hr_utility_trace('Getting the total number of days in pay period as deifned in GRE/LE...');
2090:
2091: ln_le_id := hr_mx_utility.get_legal_employer(
2092: p_business_group_id => p_business_group_id
2093: ,p_tax_unit_id => p_tax_unit_id);
2094:
2095: pay_mx_utility.get_no_of_days_for_org( p_business_group_id => p_business_group_id

Line 2216: ln_tax_subsidy_percentage := hr_mx_utility.get_tax_subsidy_percent(

2212:
2213:
2214: hr_utility_trace('ln_subsidy_lower_limit: '||ln_subsidy_lower_limit);
2215:
2216: ln_tax_subsidy_percentage := hr_mx_utility.get_tax_subsidy_percent(
2217: p_business_group_id
2218: ,p_tax_unit_id);
2219:
2220: hr_utility_trace('ln_tax_subsidy_percentage: '||ln_tax_subsidy_percentage);

Line 2923: ln_le_id := hr_mx_utility.get_legal_employer(

2919: hr_utility_trace('Number of days in the pay period : '||ln_days_in_a_period);
2920:
2921: hr_utility_trace('Getting the total number of days in pay period as deifned in GRE/LE...');
2922:
2923: ln_le_id := hr_mx_utility.get_legal_employer(
2924: p_business_group_id => p_business_group_id
2925: ,p_tax_unit_id => p_tax_unit_id);
2926:
2927: pay_mx_utility.get_no_of_days_for_org( p_business_group_id => p_business_group_id

Line 3048: ln_tax_subsidy_percentage := hr_mx_utility.get_tax_subsidy_percent(

3044:
3045:
3046: hr_utility_trace('ln_subsidy_lower_limit: '||ln_subsidy_lower_limit);
3047:
3048: ln_tax_subsidy_percentage := hr_mx_utility.get_tax_subsidy_percent(
3049: p_business_group_id
3050: ,p_tax_unit_id);
3051:
3052: hr_utility_trace('ln_tax_subsidy_percentage: '||ln_tax_subsidy_percentage);

Line 3928: hr_mx_utility.get_legal_employer(paf.business_group_id,

3924: paf.person_id
3925: FROM hr_organization_information hoi
3926: ,per_assignments_f paf
3927: WHERE hoi.organization_id =
3928: hr_mx_utility.get_legal_employer(paf.business_group_id,
3929: per_mx_ssaffl_archive.derive_gre_from_loc_scl(
3930: paf.location_id
3931: ,paf.business_group_id
3932: ,paf.soft_coding_keyflex_id