APPS.PAY_ES_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 306: FROM hr_organization_information hoi

302: AND effective_end_date;
303: --
304: CURSOR csr_get_le_details (p_wc_organization_id NUMBER) IS
305: SELECT hoi.organization_id le_id
306: FROM hr_organization_information hoi
307: WHERE hoi.org_information1 = p_wc_organization_id
308: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
309: --
310: l_wc_id hr_all_organization_units.organization_id%TYPE;