685: select count(*)
686: into l_count_wt
687: from DUAL
688: WHERE EXISTS (SELECT 1
689: FROM wip_transactions
690: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
691: and organization_id = p_eam_sub_res_rec.organization_id
692: and operation_seq_num = p_eam_sub_res_rec.operation_seq_num
693: and resource_seq_num = p_eam_sub_res_rec.resource_seq_num