DBA Data[Home] [Help]

APPS.HR_DE_ORG_INFO dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 94: FROM per_org_structure_versions sv

90: -- Cursor to return the current named hierarchy version.
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'))