APPS.HR_CLE_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 468: FROM hr_organization_information hoi

464: and p_validation_start_date between hsi.effective_start_date and nvl(hsi.effective_end_date,p_validation_end_date);
465:
466: CURSOR csr_chk_org_class IS
467: SELECT 'Y'
468: FROM hr_organization_information hoi
469: WHERE hoi.organization_id = p_organization_id
470: and hoi.org_information_context = 'CLASS'
471: and hoi.org_information1 IN ('DE_MAN_HEALTH_PROV', 'DE_ADD_SEC_PEN_PROV');
472: