APPS.HR_NL_ORG_INFO dependencies on HR_GENERAL

Line 84: AND NVL(sv.date_to, Hr_general.End_Of_time)

80: ,fnd_sessions ses
81: WHERE sv.organization_structure_id = named_hierarchy(vp_organization_id)
82: AND ses.session_id = USERENV('sessionid')
83: AND ses.effective_date BETWEEN sv.date_from
84: AND NVL(sv.date_to, Hr_general.End_Of_time)
85: ORDER BY sv.version_number DESC;
86: --
87: --
88: -- Local Variables.