DBA Data[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