APPS.PAY_ES_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 22: FROM hr_organization_information hoi

18: AND effective_end_date;
19: --
20: CURSOR csr_get_le_details (p_wc_organization_id NUMBER) IS
21: SELECT hoi.organization_id le_id
22: FROM hr_organization_information hoi
23: WHERE hoi.org_information1 = p_wc_organization_id
24: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
25: --
26: l_wc_id hr_all_organization_units.organization_id%TYPE;