APPS.HR_SA_ORG_INFO dependencies on FND_SESSIONS

Line 87: ,fnd_sessions ses

83: --
84: CURSOR c_hierarchy_version(p_organization_id NUMBER, p_organization_structure_id NUMBER) IS
85: SELECT sv.org_structure_version_id, sv.version_number
86: FROM per_org_structure_versions sv
87: ,fnd_sessions ses
88: WHERE sv.organization_structure_id = p_organization_structure_id
89: AND ses.session_id = USERENV('sessionid')
90: AND ses.effective_date BETWEEN sv.date_from AND NVL(sv.date_to, TO_DATE('31/12/4712','DD/MM/YYYY'))
91: ORDER BY sv.version_number DESC;