[Home] [Help]
154:
155: qaCollectionID := moveData.qaCollectionID;
156: if ( moveData.qaCollectionID is not null ) then
157: select count(*) into l_totalNum
158: from qa_results
159: where collection_id = moveData.qaCollectionID;
160: if ( l_totalNum = 0 ) then
161: qaCollectionID := null;
162: end if;