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.

Line 2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);

2244: where e.organization_id=l_org_id
2245: and e.org_information_context = 'NL_AMI'
2246: and e.org_information3=l_si_class
2247: and l_date_earned between fnd_date.canonical_to_date(e.org_INFORMATION1)
2248: and nvl(fnd_date.canonical_to_date(e.org_INFORMATION2),hr_general.END_OF_TIME);
2249:
2250: v_org_si_excluded org_si_excluded%ROWTYPE;
2251: l_level number;
2252: l_organization_id hr_organization_units.organization_id%TYPE;