DBA Data[Home] [Help]

APPS.JA_CN_HRMS_EXPORT_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 199: FROM per_org_structure_elements POSE

195:
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'