815: SELECT pol.id
816: FROM okl_pools pol
817: WHERE EXISTS
818: (SELECT '1'
819: FROM okl_pool_contents poc
820: WHERE poc.pol_id = pol.id
821: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE))
822: ;
823:
1097: SELECT polb.id
1098: FROM okl_pools polb
1099: WHERE EXISTS
1100: (SELECT '1'
1101: FROM okl_pool_contents pocb
1102: WHERE pocb.pol_id = polb.id
1103: AND pocb.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1104: -- Bug#2829983
1105: AND polb.status_code = 'NEW'
1302: SELECT polb.id
1303: FROM okl_pools polb
1304: WHERE EXISTS
1305: (SELECT '1'
1306: FROM okl_pool_contents pocb
1307: WHERE pocb.pol_id = polb.id
1308: AND pocb.status_code = G_POC_STS_PENDING
1309: AND polb.status_code = 'ACTIVE'
1310: );