DBA Data[Home] [Help]

APPS.PAY_MX_TAX_FUNCTIONS dependencies on PAY_MX_UTILITY

Line 981: pay_mx_utility.get_classification_id(p_classification_name);

977:
978: l_counter := 0;
979:
980: l_classification_id :=
981: pay_mx_utility.get_classification_id(p_classification_name);
982:
983: OPEN get_exempt_info(l_classification_id);
984: LOOP
985: FETCH get_exempt_info INTO l_calc_rule,

Line 1081: l_days_in_year := pay_mx_utility.get_days_in_year

1077:
1078: l_ptd_excl_current := p_ptd_earnings_amt - p_earnings_amt;
1079:
1080: -- Get number of days in year
1081: l_days_in_year := pay_mx_utility.get_days_in_year
1082: (p_ctx_business_group_id,
1083: l_tax_unit_id,
1084: l_payroll_id);
1085:

Line 1812: pay_mx_utility.get_legi_param_val('CALC_MODE',

1808: lv_action_type pay_payroll_actions.action_type%type;
1809:
1810: CURSOR csr_get_process_type IS
1811: SELECT action_type,
1812: pay_mx_utility.get_legi_param_val('CALC_MODE',
1813: legislative_parameters),
1814: pay_mx_utility.get_legi_param_val('PROCESS',
1815: legislative_parameters)
1816: FROM pay_payroll_actions

Line 1814: pay_mx_utility.get_legi_param_val('PROCESS',

1810: CURSOR csr_get_process_type IS
1811: SELECT action_type,
1812: pay_mx_utility.get_legi_param_val('CALC_MODE',
1813: legislative_parameters),
1814: pay_mx_utility.get_legi_param_val('PROCESS',
1815: legislative_parameters)
1816: FROM pay_payroll_actions
1817: WHERE payroll_action_id = p_payroll_action_id;*/
1818:

Line 1927: pay_mx_utility.get_no_of_days_for_org( p_business_group_id => p_business_group_id

1923: ln_le_id := hr_mx_utility.get_legal_employer(
1924: p_business_group_id => p_business_group_id
1925: ,p_tax_unit_id => p_tax_unit_id);
1926:
1927: pay_mx_utility.get_no_of_days_for_org( p_business_group_id => p_business_group_id
1928: ,p_org_id => ln_le_id
1929: ,p_gre_or_le => 'LE'
1930: ,p_days_month => ln_le_days_month
1931: ,p_days_year => ln_le_days_year);

Line 1937: /*ln_pay_period_days := pay_mx_utility.get_days_in_pay_period( p_business_group_id

1933: IF (ln_le_days_month IS NULL OR ln_le_days_month = -999) THEN
1934: ln_le_days_month := ln_days_in_a_period ;
1935: END IF;
1936:
1937: /*ln_pay_period_days := pay_mx_utility.get_days_in_pay_period( p_business_group_id
1938: ,p_tax_unit_id
1939: ,ln_payroll_id);*/
1940: hr_utility_trace('Average days in the month at LE :'||to_char(ln_le_days_month));
1941:

Line 2472: ln_days_in_a_month := pay_mx_utility.get_days_in_month(

2468: AND fs.effective_date BETWEEN ppf.effective_start_date
2469: AND ppf.effective_end_date
2470: AND fs.session_id = USERENV('sessionid');
2471:
2472: ln_days_in_a_month := pay_mx_utility.get_days_in_month(
2473: p_business_group_id => p_business_group_id
2474: ,p_tax_unit_id => p_tax_unit_id
2475: ,p_payroll_id => p_payroll_id);
2476: