549: l_count NUMBER := 0 ;
550:
551: BEGIN
552: SELECT count(*) into l_count
553: FROM dual
554: WHERE exists (
555: SELECT 1
556: FROM wip_operation_resources
557: WHERE operation_seq_num = p_operation_seq_num