DBA Data[Home] [Help]

APPS.PER_CN_SHARED_INFO dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 156: ,per_org_structure_versions POSV

152: CURSOR c_parent_org_id IS
153: SELECT POSE.organization_id_parent organization_id
154: FROM per_org_structure_elements POSE
155: ,per_organization_structures POS
156: ,per_org_structure_versions POSV
157: WHERE POSV.org_structure_version_id = POSE.org_structure_version_id
158: AND POS.primary_structure_flag='Y'
159: AND POS.organization_structure_id = POSV.organization_structure_id
160: AND POSE.organization_id_child = p_organization_id