APPS.EAM_MAINT_ATTRIBUTES_PUB dependencies on BOM_DEPARTMENTS

Line 406: SELECT count(department_id) INTO l_count FROM bom_departments

402:
403: -- Validate dept id
404: IF p_owning_department_id IS NOT NULL THEN
405: IF ( NOT(p_mode = 2 AND p_owning_department_id = fnd_api.g_miss_num)) THEN
406: SELECT count(department_id) INTO l_count FROM bom_departments
407: WHERE department_id = p_owning_department_id AND organization_id = x_org_id
408: AND nvl(disable_date, sysdate+1) >= sysdate;
409:
410: IF l_count = 0 THEN