APPS.HR_DE_ORG_INFO dependencies on FND_SESSIONS

Line 95: ,fnd_sessions ses

91: --
92: CURSOR c_hierarchy_version(p_organization_id NUMBER, p_organization_structure_id NUMBER) IS
93: SELECT sv.org_structure_version_id, sv.version_number
94: FROM per_org_structure_versions sv
95: ,fnd_sessions ses
96: WHERE sv.organization_structure_id = p_organization_structure_id
97: AND ses.session_id = USERENV('sessionid')
98: AND ses.effective_date BETWEEN sv.date_from AND NVL(sv.date_to, TO_DATE('31/12/4712','DD/MM/YYYY'))
99: ORDER BY sv.version_number DESC;