3074: IS
3075: SELECT 'Dept is invalid'
3076: FROM DUAL
3077: WHERE NOT EXISTS (SELECT NULL
3078: FROM BOM_DEPARTMENTS bd
3079: WHERE NVL(TRUNC(bd.disable_date) , TRUNC(p_start_effective_date) + 1)
3080: > TRUNC(p_start_effective_date)
3081: AND bd.organization_id = p_organization_id
3082: AND bd.department_id = p_dept_id