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: