APPS.EAM_ACTIVITYUTILITIES_PVT dependencies on BOM_DEPARTMENTS

Line 406: FROM bom_departments

402: IF p_organization_id IS NULL OR p_department_id IS NULL THEN
403: RETURN NULL;
404: ELSE
405: SELECT department_code INTO l_department_code
406: FROM bom_departments
407: WHERE organization_id = p_organization_id
408: and department_id = p_department_id
409: and (disable_date IS NULL
410: or disable_date > sysdate);