DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on PER_ORGANIZATION_STRUCTURES

Line 200: ,per_organization_structures POS

196: CURSOR c_parent_org_id
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