DBA Data[Home] [Help]

APPS.HR_NL_LAW_SAMEN_REPORT dependencies on PER_ORG_STRUCTURE_VERSIONS_V

Line 209: from per_org_structure_elements ose, per_org_structure_versions_v posv

205: ,P_TOP_ORGANIZATION_ID NUMBER
206: ,P_ORG_STRUCTURE_ID NUMBER)
207: is
208: select distinct ose.organization_id_child organization_id
209: from per_org_structure_elements ose, per_org_structure_versions_v posv
210: where ose.org_structure_version_id = posv.ORG_STRUCTURE_VERSION_ID
211: and ose.BUSINESS_GROUP_ID = posv.BUSINESS_GROUP_ID
212: and posv.ORG_STRUCTURE_VERSION_ID = P_ORG_STRUCTURE_VERSION_ID
213: and posv.ORGANIZATION_STRUCTURE_ID = P_ORG_STRUCTURE_ID