DBA Data[Home] [Help]

APPS.JA_CN_PS_HRMS_EXPORT_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 285: , per_org_structure_versions posv

281: pose.organization_id_parent organization_id
282: FROM
283: per_org_structure_elements pose
284: , per_organization_structures pos
285: , per_org_structure_versions posv
286: WHERE posv.org_structure_version_id = pose.org_structure_version_id
287: AND pos.primary_structure_flag='Y'
288: AND pos.organization_structure_id = posv.organization_structure_id
289: AND pose.organization_id_child = pn_organization_id