DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 471: FROM per_org_structure_versions v

467: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
468: START WITH o.organization_id_parent = l_organization_id
469: AND o.org_structure_version_id =
470: (SELECT v.org_structure_version_id
471: FROM per_org_structure_versions v
472: WHERE v.organization_structure_id = l_organization_structure_id
473: AND l_effective_date BETWEEN v.date_from
474: AND NVL(v.date_to, TO_DATE('31-12-4712','dd-mm-yyyy')));
475: --