DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 1531: FROM per_org_structure_versions posv

1527: --
1528: CURSOR csr_get_org_struct_ver_id(p_org_struct_id NUMBER
1529: ,p_date_earned DATE) IS
1530: SELECT org_structure_version_id
1531: FROM per_org_structure_versions posv
1532: WHERE organization_structure_id =p_org_struct_id
1533: AND p_date_earned BETWEEN posv.date_from
1534: AND NVL(posv.date_to,hr_general.end_of_time);
1535: