APPS.HR_MX_UTILITY dependencies on HR_GENERAL

Line 119: AND nvl(pghv.date_to, hr_general.end_of_time)

115: per_gen_hierarchy_nodes pghn_gre
116: where pgh.type = 'MEXICO HRMS'
117: and pghv.hierarchy_id = pgh.hierarchy_id
118: and p_session_date BETWEEN pghv.date_from
119: AND nvl(pghv.date_to, hr_general.end_of_time)
120: and pghv.status = 'A'
121: and pghn_loc.hierarchy_version_id = pghv.hierarchy_version_id
122: and pghn_loc.node_type = 'MX LOCATION'
123: and pghn_loc.entity_id = p_location_id

Line 457: AND NVL(hier_ver.date_to, hr_general.end_of_time);

453: AND lv.meaning = 'Active'
454: AND lv.LANGUAGE = 'US'
455: AND lv.lookup_type = 'PQH_GHR_HIER_VRSN_STATUS'
456: AND p_effective_date BETWEEN hier_ver.date_from
457: AND NVL(hier_ver.date_to, hr_general.end_of_time);
458:
459: IF (g_debug)
460: THEN
461: hr_utility.trace('Leaving '|| lv_proc);