APPS.BOM_VALIDATE_OP_SEQ dependencies on BOM_DEPARTMENTS
Line 3078: FROM BOM_DEPARTMENTS bd
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