<?xml version="1.0"?>
<queryset>

<fullquery name="ad_page_contract_filter_proc_ttracker_option_id.check_option_id">
<querytext>

select count(option_id) as id_valid_p
  from ttracker_options
  where option_id = :value and 
        package_id = :package_id
    
</querytext>
</fullquery>


<fullquery name="ad_page_contract_filter_proc_ttracker_task_id.check_task_id">      
<querytext>
      
select count(wt.task_id) as id_valid_p 
  from wf_tasks wt
  where exists (select wc.case_id
                  from wf_cases wc,
                       ttracker_tickets tt,
                       ttracker_categories tc 
                  where wt.case_id = wc.case_id
                    and wc.object_id = tt.ticket_id
                    and tt.category_id = tc.category_id
                    and tc.package_id = :package_id) 
    and wt.task_id = :value
    
</querytext>
</fullquery>

 
<fullquery name="ttracker_category_exists_p.check_category">      
      <querytext>
      
        select case when count(1) = 0 then 0 else 1 end
        from ttracker_categories
        where package_id = :package_id
    
      </querytext>
</fullquery>

 
</queryset>