188: where resource_id = v_resource_id ;
189:
190: cursor c_check_valid_resource (v_resource_id number, v_resource_type varchar2)
191: is
192: select count(*) from jtf_task_resources_vl
193: where resource_id = v_resource_id and resource_type = v_resource_type;
194:
195: l_check_valid_resource number;
196:
653: where resource_id = v_resource_id ;
654:
655: cursor c_check_valid_resource (v_resource_id number, v_resource_type varchar2)
656: is
657: select count(*) from jtf_task_resources_vl
658: where resource_id = v_resource_id and resource_type = v_resource_type;
659:
660: l_check_valid_resource number;
661: