1779: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1780: --
1781: CURSOR csr_get_work_centers(c_work_center NUMBER) IS
1782: SELECT hoi2.org_information1 work_center
1783: FROM hr_organization_information hoi1
1784: ,hr_organization_information hoi2
1785: WHERE hoi1.organization_id = hoi2.organization_id
1786: AND hoi1.org_information1 = c_work_center
1787: AND hoi1.org_information_context = 'ES_WORK_CENTER_REF'
1780: --
1781: CURSOR csr_get_work_centers(c_work_center NUMBER) IS
1782: SELECT hoi2.org_information1 work_center
1783: FROM hr_organization_information hoi1
1784: ,hr_organization_information hoi2
1785: WHERE hoi1.organization_id = hoi2.organization_id
1786: AND hoi1.org_information1 = c_work_center
1787: AND hoi1.org_information_context = 'ES_WORK_CENTER_REF'
1788: AND hoi2.org_information_context = 'ES_WORK_CENTER_REF';
1942: AND c_effective_date between paaf.effective_start_date and paaf.effective_end_date;
1943: --
1944: CURSOR csr_get_work_centers(c_work_center NUMBER) IS
1945: SELECT hoi2.org_information1 work_center
1946: FROM hr_organization_information hoi1
1947: ,hr_organization_information hoi2
1948: WHERE hoi1.organization_id = hoi2.organization_id
1949: AND hoi1.org_information1 = c_work_center
1950: AND hoi1.org_information_context = 'ES_WORK_CENTER_REF'
1943: --
1944: CURSOR csr_get_work_centers(c_work_center NUMBER) IS
1945: SELECT hoi2.org_information1 work_center
1946: FROM hr_organization_information hoi1
1947: ,hr_organization_information hoi2
1948: WHERE hoi1.organization_id = hoi2.organization_id
1949: AND hoi1.org_information1 = c_work_center
1950: AND hoi1.org_information_context = 'ES_WORK_CENTER_REF'
1951: AND hoi2.org_information_context = 'ES_WORK_CENTER_REF';