APPS.PAY_MX_TAX_FUNCTIONS dependencies on HR_GENERAL

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

270: p_range_basis = plif.legislation_info1)
271: AND hou.organization_id = p_gre_id
272: AND plif.legislation_info_type = 'MX Minimum Wage Information'
273: AND p_effective_date BETWEEN hou.date_from
274: AND NVL(hou.date_to, hr_general.end_of_time)
275: AND p_effective_date BETWEEN plif.effective_start_date
276: AND plif.effective_end_date;
277:
278: l_min_wage NUMBER;

Line 1564: l_legal_employer_name := hr_general.decode_organization(

1560: l_proc_name := g_proc_name || 'GET_MX_EE_HEAD_COUNT';
1561:
1562: hr_utility_trace('Entering ' || l_proc_name);
1563:
1564: l_legal_employer_name := hr_general.decode_organization(
1565: hr_mx_utility.get_legal_employer(
1566: p_ctx_business_group_id,
1567: p_ctx_tax_unit_id)
1568: );

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

2880: WHERE hou.organization_id = hoi.organization_id
2881: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
2882: AND hou.organization_id = P_CTX_TAX_UNIT_ID
2883: AND P_CTX_DATE_EARNED BETWEEN hou.date_from
2884: AND NVL(hou.date_to, hr_general.end_of_time);
2885:
2886: l_econ_zone varchar2(2);
2887:
2888: BEGIN