APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKC_K_ITEMS

Line 248: FROM OKC_K_Items BIT

244: WHERE KSL.Cle_ID = v_contract_service_id
245: AND BPL.Cle_ID = KSL.COVERAGE_ID
246: AND BPL.Lse_Id IN (3,16,21)
247: AND EXISTS (SELECT 'x'
248: FROM OKC_K_Items BIT
249: WHERE BIT.Cle_id = BPL.Id
250: AND Object1_Id1 = v_business_process_id
251: AND Jtot_Object1_Code = 'OKX_BUSIPROC');
252: /*

Line 257: from okc_k_items

253: Select a.id
254: from okc_k_lines_b a
255: where a.lse_id in (3,16,21)
256: and exists (select 'x'
257: from okc_k_items
258: where cle_id = a.id and
259: object1_id1 = v_business_process_id and
260: jtot_object1_code = 'OKX_BUSIPROC')
261: connect by a.cle_id = prior(a.id)