APPS.PER_MEA_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 338: from hr_organization_information hoi

334: and p_effective_date between hou.date_from and nvl(hou.date_to, hr_api.g_eot);
335: --
336: cursor csr_org_inf is
337: select null
338: from hr_organization_information hoi
339: where hoi.organization_id = p_organization_id
340: and hoi.org_information_context = 'CLASS'
341: and hoi.org_information1 = 'MEDICAL_ASSESSMENT_ORG'
342: and hoi.org_information2 = 'Y';

Line 399: -- check org exists in hr_organization_information for the relevant

395: CLOSE csr_org;
396: --
397: hr_utility.set_location(l_proc, 40);
398: --
399: -- check org exists in hr_organization_information for the relevant
400: -- organisation class.
401: --
402: OPEN csr_org_inf;
403: FETCH csr_org_inf INTO l_exists;