94: IS
95: SELECT 'Rev Comp referencing Seq Num exists'
96: FROM SYS.DUAL
97: WHERE EXISTS (SELECT NULL
98: FROM BOM_INVENTORY_COMPONENTS bic
99: , ENG_REVISED_ITEMS eri
100: WHERE TRUNC(bic.effectivity_date) >= TRUNC(p_start_effective_date)
101: AND bic.implementation_date IS NULL
102: AND bic.operation_seq_num = p_operation_seq_num