DBA Data[Home] [Help]

APPS.PER_JP_REPORT_COMMON_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 64: ,per_org_structure_versions POSV

60: IS
61: SELECT DISTINCT POSE.organization_id_child organization_id
62: FROM per_org_structure_elements POSE
63: ,per_organization_structures POS
64: ,per_org_structure_versions POSV
65: WHERE POSE.business_group_id = p_business_group_id
66: AND p_include_org_hierarchy = 'Y'
67: AND POSV.org_structure_version_id = POSE.org_structure_version_id
68: AND POS.primary_structure_flag='Y'