APPS.PAY_MX_UTILITY dependencies on HR_GENERAL

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

1139: WHERE hou.organization_id = hoi.organization_id
1140: AND hoi.org_information_context = 'MX_SOC_SEC_DETAILS'
1141: AND hou.organization_id = P_CTX_TAX_UNIT_ID
1142: AND P_CTX_DATE_EARNED BETWEEN hou.date_from
1143: AND NVL(hou.date_to, hr_general.end_of_time);
1144:
1145: l_econ_zone varchar2(2);
1146:
1147: BEGIN