[Home] [Help]
APPS.JA_CN_HRMS_EXPORT_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS
Line 201: ,per_org_structure_versions POSV
197: IS
198: SELECT POSE.organization_id_parent organization_id
199: FROM per_org_structure_elements POSE
200: ,per_organization_structures POS
201: ,per_org_structure_versions POSV
202: WHERE POSV.org_structure_version_id = POSE.org_structure_version_id
203: AND POS.primary_structure_flag='Y'
204: AND POS.organization_structure_id = POSV.organization_structure_id
205: AND POSE.organization_id_child = p_organization_id