APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKC_K_ITEMS

Line 242: FROM OKC_K_Items BIT

238: WHERE KSL.Cle_ID = v_contract_service_id
239: AND BPL.Cle_ID = KSL.COVERAGE_ID
240: AND BPL.Lse_Id IN (3,16,21)
241: AND EXISTS (SELECT 'x'
242: FROM OKC_K_Items BIT
243: WHERE BIT.Cle_id = BPL.Id
244: AND Object1_Id1 = v_business_process_id
245: AND Jtot_Object1_Code = 'OKX_BUSIPROC');
246: /*

Line 251: from okc_k_items

247: Select a.id
248: from okc_k_lines_b a
249: where a.lse_id in (3,16,21)
250: and exists (select 'x'
251: from okc_k_items
252: where cle_id = a.id and
253: object1_id1 = v_business_process_id and
254: jtot_object1_code = 'OKX_BUSIPROC')
255: connect by a.cle_id = prior(a.id)