APPS.PAY_MX_TAX_FUNCTIONS dependencies on HR_GENERAL

Line 335: AND NVL(hou.date_to, hr_general.end_of_time)

331: p_range_basis = plif.legislation_info1)
332: AND hou.organization_id = p_gre_id
333: AND plif.legislation_info_type = 'MX Minimum Wage Information'
334: AND p_effective_date BETWEEN hou.date_from
335: AND NVL(hou.date_to, hr_general.end_of_time)
336: AND p_effective_date BETWEEN plif.effective_start_date
337: AND plif.effective_end_date;
338:
339: l_min_wage NUMBER;

Line 1698: l_legal_employer_name := hr_general.decode_organization(

1694: l_proc_name := g_proc_name || 'GET_MX_EE_HEAD_COUNT';
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: );

Line 4182: AND NVL(hou.date_to, hr_general.end_of_time);

4178: WHERE hou.organization_id = hoi.organization_id
4179: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
4180: AND hou.organization_id = P_CTX_TAX_UNIT_ID
4181: AND P_CTX_DATE_EARNED BETWEEN hou.date_from
4182: AND NVL(hou.date_to, hr_general.end_of_time);
4183:
4184: l_econ_zone varchar2(2);
4185:
4186: BEGIN