APPS.OKL_POOLCONC_PVT dependencies on OKL_POOL_CONTENTS

Line 819: FROM okl_pool_contents poc

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:

Line 1101: FROM okl_pool_contents pocb

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'

Line 1306: FROM okl_pool_contents pocb

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: );