DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 235: per_org_structure_versions v,

231: FROM dual
232: UNION ALL
233: SELECT x.sub_organization_id AS organization_id
234: FROM per_org_hrchy_summary x,
235: per_org_structure_versions v,
236: per_org_structure_versions currv
237: WHERE v.org_structure_version_id = p_org_structure_version_id AND
238: v.organization_structure_id = currv.organization_structure_id AND
239: (currv.date_to IS NULL OR

Line 236: per_org_structure_versions currv

232: UNION ALL
233: SELECT x.sub_organization_id AS organization_id
234: FROM per_org_hrchy_summary x,
235: per_org_structure_versions v,
236: per_org_structure_versions currv
237: WHERE v.org_structure_version_id = p_org_structure_version_id AND
238: v.organization_structure_id = currv.organization_structure_id AND
239: (currv.date_to IS NULL OR
240: sysdate BETWEEN currv.date_from AND currv.date_to) AND